Can only be specified when a column list is used and IDENTIT

I am tried following query

SET IDENTITY_INSERT StudentSubjectRegistration ON
GO
Insert Into StudentSubjectRegistration
SELECT StudentSubjectRegistrationID, StudentSemesterRegistrationID, StudentRegCode, DivisionID, SemesterActivationID, SemesterID, BranchesSubjectDetailID,
SubjectDetailsID, SubjectCategoryID, SubjectGroupPID, NoOfAttempt, StudentStatusPID, ParentSubject, SubjectCode, FacultySubjectMappingID, OrgGrade,
OrgGradePoint, TotalMark, IsReExamRegistered, IsAllowReExam, IsEquivalence, IsMedicalReason, AwardedGrade, AwardedGradePoint, SubjectCredit,
EvalutionTypePID, CreditGradePoint, IsFeedBackSubmitted, YearID, CollegeID, IsEnabled, IsAccepted, IsAccRejected, AccComment, IsApproved, IsAppRejected,
AppComment, IsFreezed, IsArchived, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn
FROM OEPIS.dbo.StudentSubjectRegistration
WHERE (StudentRegCode = 111615003) AND (SemesterActivationID = 239) AND (SemesterID = 190) AND (YearID = 12) AND (SubjectCode IN ('CSE-16005'))
Go
SET IDENTITY_INSERT StudentSubjectRegistration Off
GO

But still error showing in sql

An explicit value for the identity column in table 'StudentSubjectRegistration' can only be specified when a column list is used and IDENTITY_INSERT is ON.

So please guide me

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Faisal Pathan8y ago
Please share your create table script.So I can help you.
sharad bhadalkar8y ago
SET IDENTITY_INSERT [dbo].StudentSubjectRegistration ON

it's not working still error showing
sharad bhadalkar8y ago
Is your "StudentSubjectRegistrationID" is auto increment ..?

yes
Amit Kumar8y ago
Hi,
Use SET IDENTITY_INSERT [dbo].StudentSubjectRegistration ON before insert the records.
Faisal Pathan8y ago
Is your "StudentSubjectRegistrationID" is auto increment ?