Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting default for almost all columns in a table?
Message
From
14/07/2012 02:46:21
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01548548
Message ID:
01548569
Views:
47
>Hi,
>
>I am wondering (want to make sure I won't regret at some point) if setting default to many columns is ok (from the stand-point of good db design practice). For example, I have a table that has 34 columns and it looks like I will have defaults set for 30 columns (some 0, some empty string ''). Is this ok? TIA.

You decide whether you prefer the convenience of having a value set by SQL engine
or risk forget to enter a value in an INSERT without an error
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform