O'Reilly logo
  • Dustin Waybright thinks this is interesting:

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.

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

When creating a column without data.