if you got this error message when trying to run this SQL: An explicit value for the identity column in table 'Student' can only be specified when a column list is used and IDENTITY_INSERT is ON.
Used below query
SET IDENTITY_INSERT StudentON;
Insert into Student(classID,ClassName,schoolID) values(1976,'Grade 1',178)
SET IDENTITY_INSERT Student OFF;
===================================================================
Thank you
There should be space between table name and ON
ReplyDelete