SQL Server Transact Basic to Expert - Insert Query with Default Values

This blog show how to use default values in Insert statements. Defaults are used in case when some value which is default to be used across the statement.

Example:

Insert into emptable
(Empname, Empid, Empdateofjoining)
Values('karthik', '1', DEFAULT)