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, 1734🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...