How to insert into a table with just one IDENTITY column?

user_22194 0
Viewed 25944

(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 ()

... won't work.

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

identity sql-server sql
5 Answers

This should work:

INSERT INTO GroupTable DEFAULT VALUES
DJ_104920

Here you go:

INSERT INTO GroupTable DEFAULT VALUES
user_959760

Can you try using a Sequence or something similar? Where you select from a Sequence and it will give you the next value in the sequence.

Mike_Pone_164040

This will work actually--

insert into TABLE default values

user_185248030
Related