Collections:
DEFAULT - Using Column Default Values in INSERT Statements in SQL Server
How To Use Column Default Values in INSERT Statements in SQL Server?
✍: FYIcenter.com
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.
⇒ Providing Column Names in INSERT Statements in SQL Server
⇐ "INSERT INTO" - Inserting a New Row into a Table in SQL Server
2016-11-03, 1478🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...