Mega Code Archive

 

Categories / MSSQL / Constraints

 

NOT NULL column and NULL column

1> CREATE TABLE MyTable 2>      ( Category nVarChar(50) NOT NULL 3>    , MyDescription nVarChar(50) NULL 4> ) 5> 6> 7> INSERT MyTable (Category) VALUES ('Category1') 8> 9> SELECT * FROM MyTable 10> GO (1 rows affected) Category                                           MyDescription -------------------------------------------------- ----------------- Category1                                          NULL (1 rows affected) 1> 2> drop table MyTable 3> GO 1>