Sometimes you might need to insert data into multiple tables with identity columns. While you might think you can SET IDENTITY_INSERT ON for your tables and be on your merry way, the process is a little more nuanced than that.
Subscribe and turn on notifications to never miss a weekly video: https://www.youtube.com/c/DataWithBert?sub_confirmation=1
Read the full post with examples:
https://bertwagner.com/2019/06/25/multiple-identity-inserts/
Follow me on Twitter:
https://twitter.com/bertwagner
