codeulike codeulike - 1 month ago 4
SQL Question

How to insert into a table with just one IDENTITY column

(Came up with this question in the course of trying to answer this other one)

Consider the following MS-SQL table, called GroupTable:


GroupID
-------
1
2
3


where GroupID is the primary key and is an Identity column.

How do you insert a new row into the table (and hence generate a new ID) without using IDENTITY_INSERT ON?

Note that this:

INSERT INTO GroupTable() Values ()


... wont work.

edit: we're talking SQL 2005 or SQL 2008 here.

DJ. DJ.
Answer

This should work:

INSERT INTO GroupTable DEFAULT VALUES