Table-Valued Parameters (OLE DB)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Download OLE DB driver

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).

Remarks

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 SQL Server parameter types. The OLE DB Driver for SQL Server provides creation, discovery, specification, binding, and schema interfaces.

In This Section

• Table-Valued Parameter Rowset Creation

• Table-Valued Parameter Type Discovery

• Executing Commands Containing Table-Valued Parameters

• Inserting Data into Table-Valued Parameters

• Schema Rowsets Changed for OLE DB Table-Valued Parameters

• OLE DB Table-Valued Parameter Type Support

• OLE DB Table-Valued Parameter Type Support (Methods)

• OLE DB Table-Valued Parameter Type Support (Properties)

See Also

OLE DB Driver for SQL Server Programming
Use Table-Valued Parameters (OLE DB)