Insert to a table with default value : Default « Constraints « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Constraints
  3. Default
2> CREATE TABLE T (
3>     int1 int,
4>     bit1 bit NOT NULL DEFAULT 0,
5>     rvr1 timestamp,
6>     usr1 nvarchar(128) DEFAULT USER,
7>     createtime datetime DEFAULT CURRENT_TIMESTAMP
8> )
9> GO
1>
2> INSERT T (int1, bit1) VALUES (3, 1)
3> GO

(1 rows affected)
1>
2> drop table t;
3> GO








7.6.Default
7.6.1.The syntax for defining a default
7.6.2.DEFAULT Constraints
7.6.3.Default int type value and default char type value
7.6.4.Using the system date as a default parameter.
7.6.5.Column with default random value
7.6.6.Insert to a table with default value
7.6.7.Designating Default Column Values: Assign Zeroes Instead of Null Values
7.6.8.Dropping Defaults