Define default constraint

Define default constraint.

- These constraints are a special case of column defaults.

- It provides a default value to a column when the INSERT INTO statement does not provide a specific value.

- Default constraint is used to fill a column with default value defined during creation of table if nothing is supplied while inserting data.

- IDENTITY columns and timestamp columns cannot be associated with default constraint.

- It is used to insert a default value into a column.
What is a transaction and what are ACID properties?
Transaction encapsulates SQL commands and work as a single unit........
Different isolation levels defined in SQL Sever
Isolation levels determine the degree of isolation of data during concurrent access.......
What is lock escalation?
Lock escalation is the process of converting low level locks (row locks, page locks) into higher level locks (table locks)........
Post your comment