StackOverflow: How to insert into a table with just one IDENTITY column
I had a problem at work today, and this post on Stack Overflow resolved it.
http://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
