Saturday, 10 November 2012

What are defaults? Is there a column to which a default can't be bound? | SQL DBA

A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can't have defaults bound to them. See CREATE DEFUALT in books online.
SQL Server architecture (top)

No comments: