Two constraints for one single column: Not NULL and default value


1> CREATE TABLE T (
2>     int1 int IDENTITY PRIMARY KEY,
3>     bit1 bit NOT NULL DEFAULT 0
4> )
5> GO
1> INSERT T (bit1) VALUES (1)
2> GO

(1 rows affected)
1> INSERT T (bit1) VALUES (0)
2> GO

(1 rows affected)
1> INSERT T DEFAULT VALUES
2> GO

(1 rows affected)
1> INSERT T (int1, bit1) VALUES (4,1)
2> GO
Msg 544, Level 16, State 1, Server JAVA2S\SQLEXPRESS, Line 1
Cannot insert explicit value for identity column in table 'T' when IDENTITY_INSERT is set to OFF.
1>
2> select * from t
3> GO
int1        bit1
----------- ----
          1    1
          2    0
          3    0

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

Related examples in the same category

1.	Data length: greater than 0
2.	Add constraints for two columns
3.	Constraint: PRIMARY KEY
4.	Constraint check (Options)

Two constraints for one single column: Not NULL and default value : Column Constraints « Constraints « SQL Server / T-SQL

Related examples in the same category