DEFAULT

How explicitly insert default value ? TIP #72

  Suppose, sometimes you just need  entry in the table with all the default values. For example you have a Student table which looks like as below CREATE TABLE #tmpStudent (StudentId INT IDENTITY(1,1),                          FirstName VARCHAR(100) DEFAULT ‘RAJAT’,                          Course    VARCHAR(100) DEFAULT ‘MATHS’)   Now , suppose for in some situation we need just default entry for …