Bound defaults are similar to rules in that you first create a bound default and then bind it to a column or set of columns. Bound defaults are also similar to rules in that they are slated for removal in a future version of SQL Server. This section covers the basics of bound defaults, but you should keep in mind that Microsoft recommends you avoid using them for new development work.
You use the
CREATE DEFAULT command to establish a default that can be bound to a column at a later time. The
CREATE DEFAULT syntax is as follows:
CREATE DEFAULT [ schema_name . ] default_nameAS constant_expression [ ; ]
constant_expression can include any constant, built-in function, or mathematical expression. It cannot ...