sathishmcc (1/4/2011)
Im getting the error while running the queryServer: Msg 8101, Level 16, State 1, Line 7
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.
Interesting. Did you just copy/paste the code or did you change anything?
What version of SQL Server are you running?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP