Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What does the VTXCMD() multirow option do?

option vtxcmd
0
Posted

What does the VTXCMD() multirow option do?

0

Multirow applies to Sybase and SQL Server. These have a bulk interface called bcp which greatly improves bulk insert performance but the DBMS must be enabled to do so. Some sites do not enable their DBMS so the bcp calls fail. Setting multirow = no, the default, means we use the bulk interface (bcp) to do bulk inserts. Multirow = yes means we do individual inserts. There is still some performance enhancement in this case because the data will be sent across in batches.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123