The server-wide column default is NOT NULL but can be overridden at the database level and at the session level. Use the sp_dboption "ANSI null default" to set the database default. Set the session level default by using the SET statement to set ANSI_Null_Dflt_On or ANSI_Null_Dflt_Off.
It is recommended that you always specify NULL or NOT NULL when creating the column.
The default column nullability is NOT NULL.
It is recommended that you always specify NULL or NOT NULL when creating the column.