AnsweredAssumed Answered

Using dynamic insert with identity field?

Question asked by brenton.lohrisch744101 on Nov 2, 2016

Hi folks. I'm likely missing something really obvious here, but I can't figure out how to set identity_insert on as part of a dynamic insert into an SQL table. I've got an existing table with an identity field that I need to insert values into from my source data. I've got all the other values being successfully inserted via the dynamic insert, but obviously I need to enable identity_insert on the target table in order to transfer the values into that field. Can someone please point me in the right direction for how to achieve this?

Outcomes