1> CREATE TABLE MyTable (MyID Int IDENTITY(-1000000, 100) NOT NULL
2> ,MyDescription NVarChar(50) NOT NULL)
3>
4> insert mytable (mydescription) values ('a');
5> insert mytable (mydescription) values ('b');
6> insert mytable (mydescription) values ('c');
7>
8> select * from mytable
9> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
MyID MyDescription
----------- --------------------------------------------------
-1000000 a
-999900 b
-999800 c
(3 rows affected)
1>
2>
3> SELECT @@IDENTITY AS LastIdentity
4>
5> drop table MyTable
6> GO
LastIdentity
----------------------------------------
-999800
(1 rows affected)
1>
2>