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

654    Asked by AbhinavPillai in SQL Server , Asked on Jun 20, 2021

 I have the below error “cannot insert explicit value for identity column” when I execute the following script. What is the error about, and how it can be resolved?

Insert table(OperationID,OpDescription,FilterID)

values (20,'Hierachy Update',1)

Error:

Server: Msg 544, Level 16, State 1, Line 1

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

Answered by Akansha Chawla

Your Answer

Interviews

Parent Categories