다음을 통해 공유


bcp_batch

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

구문

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.

주의

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

도움말 및 정보

SQL Server 2005 지원 받기