ErcanOPAK.com

SET IDENTITY_INSERT MyTable ON

INSERT INTO MyTable 
    (IdentityColumn, col2, col3, ...)
VALUES 
    (IdentityValue, col2value, col3value, ...)

SET IDENTITY_INSERT MyTable OFF

Note that you can not insert explicit value for identity column in table ‘MyTable’ when IDENTITY_INSERT is set to OFF.