DEFAULT - Using Column Default Values in INSERT Statements in SQL Server

Q

How To Use Column Default Values in INSERT Statements in SQL Server?

✍: FYIcenter.com

A

If a column is defined with a default value in a table, you can use the key word DEFAULT in the INSERT statement to take the default value for that column. The following tutorial exercise gives a good example:

INSERT INTO fyi_links VALUES (102, 
  'dba.fyicenter.com', 
  NULL,
  0,
  DEFAULT)
GO
(1 row(s) affected)

SELECT * FROM fyi_links
GO
id   url                notes  counts  created
101  dev.fyicenter.com  NULL   0       2006-04-30
102  dba.fyicenter.com  NULL   0       2007-05-19

The default value, getdate(), is used for "created" column, which gives the current date.

 

Using INSERT, UPDATE and DELETE Statements in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-03, 436👍, 0💬