1> -- Created with an IDENTITY property that is set to start at 1,000,000 and decrement by 100 for every row added
2>
3> CREATE TABLE MyTable (MyID Int IDENTITY(1000000, -100) NOT NULL
4> ,MyDescription NVarChar(50) NOT NULL )
5> GO
1> insert mytable (mydescription) values ('a');
2> GO
(1 rows affected)
1> insert mytable (mydescription) values ('b');
2> GO
(1 rows affected)
1> insert mytable (mydescription) values ('c');
2> GO
(1 rows affected)
1> select * from mytable
2> GO
MyID MyDescription
----------- --------------------------------------------------
1000000 a
999900 b
999800 c
(3 rows affected)
1> drop table MyTable
2> GO
1>
2>