bcp_batch
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
Commits all rows previously bulk copied from program variables and sent to SQL Server by bcp_sendrow.
Syntax
DBINT bcp_batch (HDBC
hdbc);
Arguments
hdbc
Is the bulk copy-enabled ODBC connection handle.
Returns
The number of rows saved after the last call to bcp_batch, or -1 in case of error.
Remarks
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.