开发者

Is it possible to get feedback on duplicates with SqlBulkCopy

开发者 https://www.devze.com 2022-12-26 17:17 出处:网络
I\'m using SqlBulkCopy to insert into a table with IGNORE_DUP_KEY on. This means that exceptions aren\'t thrown when duplicate is encountered, instead it passes over it and continues.

I'm using SqlBulkCopy to insert into a table with IGNORE_DUP_KEY on. This means that exceptions aren't thrown when duplicate is encountered, instead it passes over it and continues.

开发者_运维百科

Is it possible to get feedback on which rows were inserted or ignored?


Unfortunately, no.

Not without using a staging table and seeing what is missing after moving to the real table, or checking for dupes after loading the staging table

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号