Specify Default Values for Columns

You can specify a default value that will be entered in the column in SQL Server 2014 by using SQL Server Management Studio or Transact-SQL. If you do not assign a default value and the user leaves the column blank, then:

msdn.microsoft.com