bcp_batch

 

System_CAPS_ICON_warning.jpg Warning

SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. Avoid using SNAC in new development work, and plan to modify applications that currently use it. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database.

Commits all rows previously bulk copied from program variables and sent to SQL Server 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.

Bulk Copy Functions

Community Additions

ADD
Show: