Default Values and Collations

If you specify a NOT NULL constraint for a column, one of the following must happen:

• You must define a default value.
• Every INSERT or UPDATE command on the column must leave it with a specified value.

The default can be specified as a literal, a user value function, a datetime value function, or NULL (if you don't specify a default, the column is assumed to be nullable).