| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|
Table-valued parameters (Native Client OLE DB provider) |
Table-Valued Parameters in SQL Server Native Client (OLE DB) |
markingmyname |
maghan |
03/14/2017 |
sql |
native-client |
reference |
|
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
This section describes support for table-valued parameters in [!INCLUDEssNoVersion] Native Client OLE DB Provider. For additional overview information, see Table-Valued Parameters (SQL Server Native Client). For a sample, see Use Table-Valued Parameters (OLE DB).
Currently, you can send multirow data to the server as parameters to a procedure with parameter sets (the DBPARAMS parameter in ICommand::Execute). With parameter sets, every element of the set has to be sent in a separate remote procedure call (RPC) request to the server. Table-valued parameters provide similar functionality, but there is better integration with the server. This reduces the number of RPC requests and enables set-based operations on the server.
Table-value parameters are supported in [!INCLUDEssNoVersion] Native Client OLE DB Provider as OLE DB Rowset objects. Any Rowset object could be provided by the consumer (that is, the client application using [!INCLUDEssNoVersion] Native Client OLE DB Provider) as a placeholder for table-valued parameter parameters. Table-valued parameters are treated like other [!INCLUDEssNoVersion] parameter types. The [!INCLUDEssNoVersion] Native Client OLE DB Provider provides creation, discovery, specification, binding and schema interfaces.
SQL Server Native Client (OLE DB)
Use Table-Valued Parameters (OLE DB)