malleswarareddy_m (6/27/2010)
sheik (6/27/2010)
The table should be created with the identity (-1,-1). Then only we can get this result. Must be a typo error???.It's correct.
Right.
Create Table MyTable1( mainkey int not null identity (-1,-1))
GO
insert into MyTable1 default values
insert into MyTable1 default values
insert into MyTable1 default values
Select * from MyTable1
drop table MyTable1
Now this code gives -1,-2,-3
Typing error. Lost my point...