| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | apiname | apitype | |
|---|---|---|---|---|---|---|---|---|---|---|---|
ISSCommandWithParameters (OLE DB driver) |
Learn how the ISSCommandWithParameters interface supports SQL Server XML and user-defined types in OLE DB Driver for SQL Server. |
David-Engel |
davidengel |
06/14/2018 |
sql |
connectivity |
reference |
|
ISSCommandWithParameters (OLE DB) |
COM |
[!INCLUDE SQL Server]
[!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