Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
Sends a row of data from program variables to SQL Server.
Syntax
RETCODE bcp_sendrow (
HDBC hdbc);
Arguments
hdbc
Is the bulk copy-enabled ODBC connection handle.
Returns
SUCCEED or FAIL.
Remarks
The bcp_sendrow function builds a row from program variables and sends it to SQL Server.
Before calling bcp_sendrow, you must make calls to bcp_bind to specify the program variables containing row data.
If bcp_bind is called specifying a long, variable-length data type, for example, an eDataType parameter of SQLTEXT and a non-NULL pData parameter, bcp_sendrow sends the entire data value, just as it does for any other data type. If, however, bcp_bind has a NULL pData parameter, bcp_sendrow returns control to the application immediately after all columns with data specified are sent to SQL Server. The application can then call bcp_moretext repeatedly to send the long, variable-length data to SQL Server, a chunk at a time. For more information, see bcp_moretext.
When bcp_sendrow is used to bulk copy rows from program variables into SQL Server tables, rows are committed only when the user calls bcp_batch or bcp_done. The user can choose to call bcp_batch once every n rows or when there is a lull between periods of incoming data. If bcp_batch is never called, the rows are committed when bcp_done is called.
For information about a breaking change in bulk-copying beginning in SQL Server 2005 (9.x), see Performing Bulk Copy Operations (ODBC).