An explicit value for the identity column in table IDENTITY_INSERT is ON code example

Example: An explicit value for the identity column in table

SET IDENTITY_INSERT archive_table ON;

INSERT INTO archive_table (field1, field2, ...)
  SELECT field1, field2, ...
  FROM source_table;

SET IDENTITY_INSERT archive_table OFF;