Up Prev Next
From: Julia Stone <Julia dot Stone at msdw dot com>
Subject: Is bcp_sendrow() my best option?
Date: Jun 29 2000 2:25PM
I read about using bcp_sendrow() to send an array reference ( using a
loop), and using bcp_batch to commit the rows once the loop is
complete. I would like to know what would be the best way to insert a
number of rows at once, as opposed to inserting a row at a time with a
loop. Although bcp_sendrow is supposed to be faster than inserting with
a loop, I would prefer to insert a number of rows at once, and then
commit. I had hoped that I would be able to accomplish this using some
form of BCP. Any suggestions? Thanks.