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)
Solution:
we have to specify full column list
insert into tablename(specify here)
select spectify here from tablename
(or)
No comments:
Post a Comment