| title | Table-valued parameters (OLE DB driver) | ||
|---|---|---|---|
| description | These articles describe support for table-valued parameters in OLE DB Driver for SQL Server, including parameter rowset creation and parameter type discovery. | ||
| author | David-Engel | ||
| ms.author | davidengel | ||
| ms.date | 06/14/2018 | ||
| ms.service | sql | ||
| ms.subservice | connectivity | ||
| ms.topic | reference | ||
| ms.custom |
|
||
| helpviewer_keywords |
|
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB]
[!INCLUDEDriver_OLEDB_Download]
This section describes support for table-valued parameters in OLE DB Driver for SQL Server. For additional overview information, see Table-Valued Parameters (OLE DB Driver for SQL Server). 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. It reduces the number of RPC requests and enables set-based operations on the server.
Table-value parameters are supported in OLE DB Driver for SQL Server as OLE DB Rowset objects. Any Rowset object could be provided by the consumer (that is, the client application using OLE DB Driver for SQL Server) as a placeholder for table-valued parameter parameters. Table-valued parameters are treated like other [!INCLUDEssNoVersion] parameter types. The OLE DB Driver for SQL Server provides creation, discovery, specification, binding, and schema interfaces.
OLE DB Driver for SQL Server Programming
Use Table-Valued Parameters (OLE DB)