A table could also be created so that the seed value was negative and the increment was positive: : Identity « Sequence Indentity « SQL Server / T-SQL Tutorial
15. 1. 12. A table could also be created so that the seed value was negative and the increment was positive:
4> CREATE TABLE MyTable (MyID Int IDENTITY(-1000000, 100) NOT NULL
5> ,MyDescription NVarChar(50) NOT NULL)
6> GO
1>
2>
3> drop table MyTable;
4> GO
1>
By default, once a column has been assigned the IDENTITY property,
SQL Server does not allow explicit values to be inserted into it.