开发者

Is it possible to get feedback on duplicates with SqlBulkCopy

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜