1>
2> -- Seed value was negative and the increment was positive:
3>
4> CREATE TABLE MyTable (MyID Int IDENTITY(-1000000, 100) NOT NULL
5> ,MyDescription NVarChar(50) NOT NULL)
6> 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>
2> drop table MyTable
3> GO
1>