Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining


Commits all rows previously bulk copied from program variables and sent to SQL Server by bcp_sendrow.

DBINT bcp_batch (HDBC


Is the bulk copy-enabled ODBC connection handle.

The number of rows saved after the last call to bcp_batch, or -1 in case of error.

Bulk copy batches define transactions. When an application uses bcp_bind and bcp_sendrow to bulk copy rows from program variables to SQL Server tables, the rows are committed only when the program calls bcp_batch or bcp_done.

You can call bcp_batch once every n rows or when there is a lull in incoming data (as in a telemetry application). If an application does not call bcp_batch the bulk copied rows are committed only when bcp_done is called.

Community Additions

© 2015 Microsoft