Cannot insert explicit value for identity column in
table 'INCOMING_TEMP' when IDENTITY_INSERT is set to OFf
hi garry,
you will have to SET option identity_insert on the table. also while
inserting you will have to specify column list.
ex:
set identity_insert <table> on
insert into <table> (col1, col2) values(1,1)
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment