vb6批量插入数据库 [英] vb6 Bulk Insert into a database

问题描述

VB6：有没有办法将批量ResultSet行插入数据库，而不是使用循环。

VB6 : Is there any way to insert bulk ResultSet rows into a database, instead of using the loop.

推荐答案

我从你的问题中理解的是你想要在数据库的某个表中构建插入数据。如果这是你想要的那么你可以做到。您可以构建一个包含要插入的数据的xml，并将其传递给存储过程。在该存储过程中，您可以使用XML支持的插入一次插入行。希望这可以解决您的问题。

What i understood from your question is that you want to builk insert data in some table in the database. If this is what you want then yes you can do that. You could build an xml that contain the data that you want to insert and pass it to a stored procedure. In that stored procedure you can insert rows in one go using XML suported inserts. Hopes this could solve your problem.

这篇关于vb6批量插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！