Identity columns are used in SQL Server to automatically generate sequential integer values as new rows are inserted into a table. Under normal circumstances an explicit value cannot be specified. However, sometimes this is essential.
...
Go to the complete details ...