Friday, April 28, 2017

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

I have the below error 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.


No comments:

Post a Comment