Tag Archives: identity

T-SQL: INSERT for Table w/ Only IDENTITY Column

In the event that you wish to insert a record into a SQL Server table that contains only a single column, and that column is an IDENTITY column, here is the statement: INSERT INTO dbo.TableName DEFAULT VALUES; I am primarily … Continue reading

Posted in SQL | Tagged , , , | Comments Off