Friday 28 April 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

c++ - Does curly brackets matter for empty constructor?

Those brackets declare an empty, inline constructor. In that case, with them, the constructor does exist, it merely does nothing more than t...