Create Table MyTable( mainkey int not null identity (-1,1))
GO
insert into MyTable default values insert into MyTable default values insert into MyTable default values
Select * from MyTable
this will give result as this
-1
0
1
I think this type of question three weeks ago.this question is similar to the question on may 31 st 2010.
Malleswarareddy
I.T.Analyst
MCITP(70-451)