The DEFAULT constraint is used to set a default value for a column. The default value will be added to all new records, if no other value is specified. # Default constraint using CREATE table ...

The DEFAULT constraint is used to set a default value for a column. This default value is automatically assigned when no value is provided during an insert operation.

Using SQL Server 2000.In a table, I want to default a column 'BillingName' to another column's value in that same table, which is named 'Name'.Using Enterprise Manager, I can normally only set ...