Edit

bcp_batch

  • Article

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.

See Also

Bulk Copy Functions