Default values

[Phylum]

When you create an SQL Table via VB .NET or SQL server 2000 you can fill in defult values for columns. Is there any way to set these values in code and save them to the DB, so that any record create henceforth will have those default values?

Phylum

 

[wyrd]

You specify default values when you create a table. You can also change the defaults when you alter a table.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_create2_8g9x.asp?frame=true

http://msdn.microsoft.com/library/en-us/tsqlref/ts_aa-az_3ied.asp?frame=true

 

[Phylum]

Is there a way to do it through code using VB .NET?

 

[wyrd]

DataColumn.DefaultValue

If you arent using DataTables then youll have to be more specific. When all else fails, make constants. *shrug*

 

[Phylum]

So basically if I add a nw row and change the default values of each column and then update, it will record the defaults to the DB?

 

[wyrd]

Refer to my link above on ALTER TABLE.