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 ggl_links VALUES (102,

'www.rendc.org',

NULL,

0,

DEFAULT)

GO

(1 row(s) affected)

SELECT * FROM fyi_links

GO

id url notes counts created

101 www.rendc.org NULL 0 2006-04-30

102 www.rendc.org NULL 0 2007-05-19

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