Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Verification on performance
Message
 
 
To
04/10/2010 13:36:05
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01483774
Message ID:
01483886
Views:
37
>>It doesn't sound right. If you included DEFAULT for new column it should be used. Double check that you specified it correctly.
>
>DEFAULT only takes it from now on. It doesn't affect existing data. It required the use of WITH VALUES. This has resolved the issue.

Only if column has NULL attribute. If you create it as NOT NULL, default values will be used for all rows.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform