Viewing 2 posts - 1 through 2 (of 2 total)
Create Table MyTable
(
mainkey int not null identity (-1,-1)
)
GO
insert into MyTable default values
Select * from MyTable
== > ok in...
July 1, 2010 at 9:08 am
#1187716
in identity (-1,1) no first paramaeter shows number start from and second parameter shows number increment by mentioned. in that case "mainkey" will start from -1 and increased by 1....
June 30, 2010 at 12:03 am
#1186859