Tag Info

New answers tagged


If your column definition does not have default constraint and it is nullable, the nullable field will have null mark, when you add a row even when you specify DEFAULT keyword for your insert value. For example for the following table definition CREATE TABLE Test( ColA [nvarchar](50) NOT NULL, COLB [nvarchar](50) NULL) The first three insert ...

Top 50 recent answers are included