title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | apilocation | apiname | apitype | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
bcp_batch |
bcp_batch |
markingmyname |
maghan |
03/14/2017 |
sql |
native-client |
reference |
|
sqlncli11.dll |
bcp_batch |
DLLExport |
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
Commits all rows previously bulk copied from program variables and sent to [!INCLUDEssNoVersion] by bcp_sendrow.
DBINT bcp_batch (HDBC
hdbc);
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.