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

Question

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

Accepted Answer

This should work:

```
INSERT INTO GroupTable DEFAULT VALUES 
```

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

Solution

Problem