.net - How can i solve "An explicit value for the identity column in table"? -


If I try to add some data to my table error:

< P> Error: Message 8101, Level 16, State 1, Line 1 In Table 'ENG_PREP', a clear value for the Identity column can only be specified when a column list is used and IDENTITY_INSERT is turned on. Enter 

  in ENG_PREP VALUES ('572012-01-1,572012-01-2,572012-01-3,572013-01-1,572013-01-2', '' '500', '', 'A320PA 0-1-A', 'Removal of LH wing safety rasp', '', '', '', '0', '', 'AF', '12 -00-00-081-001 ',' ',' ',' ',' ',' ',' ',' ')

If you want to type in the Identity column, 

  SET IDENTITY_INSERT at YourTableName

Use as if the error message suggests.

Otherwise, do not try to write in the identity column.


Comments

Post a Comment