Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Wednesday, 17 September 2014

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

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

Solution:

we have to specify full column list

insert into tablename(specify here)
select spectify here from tablename





(or)