InnerException = {"Cannot insert explicit value for identity column in table 'HRDeductionEmployees' when IDENTITY_INSERT is set to OFF."} code example

Example: Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.

SET IDENTITY_INSERT MyTable ON
 
-- INSERT INTO MyTable...
 
SET IDENTITY_INSERT MyTable OFF