I had a problem at work today, and this post on Stack Overflow resolved it.

//stackoverflow.com/questions/850327/how-to-insert-into-a-table-with-just-one-identity-column

CREATE Table myTable ( id int identity(1,1) )

INSERT INTO myTable DEFAULT VALUES