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)
SQL Server Transact Basic to Expert - Insert Query with Default Values
SQL Server Transact Basic to Expert - Insert Query with Default Values
Join the conversation! Your thoughts help the community grow.