Sunday, January 9, 2011

How to insert into a table with just one IDENTITY column

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

Create table singleIdTable ( nId int identity(1,1))
insert into singleIdTable Default values
Select * from singleIdTable 

No comments:

Post a Comment