What is the use of Default keyword in Sql Server?

Answer:

Default keyword is used for setting default value to any columns so that whenever any record is inserted in table,that column will also have a value.We do not need to pass column
name in Insert statement.We generally give default value for date related columns,boolean or bit columns where we have Yes and No value and so on.

For Example:-

CREATE TABLE Test

(

   Test_Id int identity,

   Test_Name Nvarchar(50),

   Created_Date SmallDatetime default getdate(),

   Is_Active bit default 'N'

)