If you don’t want to allow NULL in the column, but you do want to specify some default value to indicate that the column has not yet been populated, you can specify a DEFAULT constraint by adding the DEFAULT clause right after saying NOT NULL.
- 8. Creating Tables and Enforcing Data Integrity
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
When creating a column without data.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/68690/