Answers for "cannot insert explicit value for identity column in table 'customers' when identity_insert is set to off.db-lib error message 20018, severity 16:\ngeneral sql server error: check messages from the sql server\n")"

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

Posted by: Guest on December-08-2020

Code answers related to "cannot insert explicit value for identity column in table 'customers' when identity_insert is set to off.db-lib error message 20018, severity 16:\ngeneral sql server error: check messages from the sql server\n")"