How to turn off identity for a database column of a table
If I understand you correctly, try this one -

SET IDENTITY_INSERT &lt;your_table&gt; ON

INSERT INTO ... (ID, ...)

SET IDENTITY_INSERT &lt;your_table&gt; OFF