Microsoft® SQL Server 2012 Unleashed

Bound Defaults

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:

Click here to view code image

CREATE DEFAULT [ schema_name . ] default_nameAS constant_expression [ ; ]

constant_expression can include any constant, built-in function, or mathematical expression. It cannot ...