| title | ISSCommandWithParameters (OLE DB driver) | |
|---|---|---|
| description | Learn how the ISSCommandWithParameters interface supports SQL Server XML and user-defined types in OLE DB Driver for SQL Server. | |
| author | David-Engel | |
| ms.author | davidengel | |
| ms.date | 06/14/2018 | |
| ms.service | sql | |
| ms.subservice | connectivity | |
| ms.topic | reference | |
| ms.custom |
|
|
| helpviewer_keywords |
|
|
| apiname | ISSCommandWithParameters (OLE DB) | |
| apitype | COM |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics PDW FabricSQLDB]
[!INCLUDEDriver_OLEDB_Download]
ISSCommandWithParameters interface exposes support for [!INCLUDEssNoVersion] XML and user-defined types (UDT). It's an optional interface that inherits from the core OLE DB interface ICommandWithParameters. In addition to the three methods inherited from ICommandWithParameters; GetParameterInfo, MapParameterNames, and SetParameterInfo; ISSCommandWithParameters provides two new methods that are used to handle server-specific data types.
Note
The ISSCommandWithParameters interface can be used when Service Components are used, but the Service Components won't use this interface.
| Method | Description |
|---|---|
| ISSCommandWithParameters::GetParameterProperties (OLE DB) | Returns one SSPARAMPROPS property set structure in the array for each UDT or XML parameter passed to the command, but none is returned for other types of parameters. |
| ISSCommandWithParameters::SetParameterProperties (OLE DB) | Sets the parameter properties on a per parameter basis by ordinal, or sets bulk parameter properties by specifying an array of SSPARAMPROPS structures. |
Interfaces (OLE DB)
Using XML Data Types
Using User-Defined Types