Cannot insert explicit value for identity column in table ‘tbl_x’ when IDENTITY_INSERT is set to OFF

Problem:

SQL error kod inserta u polje koje je označeno kao identity

Cannot insert explicit value for identity column in table ‘tbl_x’ when IDENTITY_INSERT is set to OFF

 

Rješenje:

SET IDENTITY_INSERT tbl_x ON

 

 

This entry was posted on Wednesday, November 23rd, 2011 at 10:19 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.