Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

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

ayi

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

ayi

<t>You're inserting values for OperationId that is an identity column.<br/>
<br/>
You can turn on identity insert on the table like this so that you can specify your own identity values.<br/>
<br/>

SET IDENTITY_INSERT Table1 ON<br/>
<br/>
INSERT INTO Table1<br/>
/*Note the column list is REQUIRED here, not optional*/<br/>
            (OperationID,<br/>
             OpDescription,<br/>
             FilterID)<br/>
VALUES      (20,<br/>
             'Hierachy Update',<br/>
             1)<br/>
<br/>
SET IDENTITY_INSERT Table1 OFF <br/>
<br/>
```</t>