SQL批量插入 - 是全部还是全部插入 [英] SQL Bulk Insert - is it an all or nothing insert

问题描述

sql批量是插入'全有或全无'加载还是幕后发生的事情，只有不良记录被拒绝并且好记录加载？

Is the sql bulk insert an 'all-or-nothing' load or is something going on behind the scenes where only the bad records get rejected and good records load?

推荐答案

实际上有几种批量导入数据的方法。请参阅 http://msdn.microsoft.com/en-us/library/ms175937.aspx [ ^ ]



每个选项都不同。您需要阅读每一个并找到最适合您需求的那个。

There are actually several methods for bulk importing data. See http://msdn.microsoft.com/en-us/library/ms175937.aspx[^]

Each option is different. You'll want to read up on each one and find the one that most fits your needs.

这篇关于SQL批量插入 - 是全部还是全部插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！