# Thursday, October 01, 2009

SQL Server - Insert to table with ALL default values

If you're trying to do an insert to a table where every column has a default value (or is an identity column), then SQL Server will give you an error if you don't specify 'something' in the field list/values clause... Or so I thought...

This is so simple it's funny, but not so simple to find in the documentation:

INSERT INTO TableName DEFAULT VALUES



SQL Server
posted on Thursday, October 01, 2009 9:01:02 AM (AUS Eastern Standard Time, UTC+10:00)  #    Comments [0]
Related posts:
SQL Server Stored Procedure to disable / enable all foreign keys and constraints in a database
HOW TO Use SQL Server DTS Transform Data Task to export to dynamic Excel spreadsheet file
Using local SQL 2005 Express databases, |DataDirectory| setting and SQLBulkCopy with SemiColon delimited text files
Create SQL Server User and Role Script to execute Stored Procedures Only
Refactoring the inefficient data loop
Search SQL Server Stored Procedures for any text string
Comments are closed.