| title | ISSCommandWithParameters (OLE DB) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql | |
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | |
| ms.reviewer | ||
| ms.technology | native-client | |
| ms.topic | reference | |
| apiname |
|
|
| apitype | COM | |
| helpviewer_keywords |
|
|
| ms.assetid | 3419b7f3-36a3-4863-816e-e641e4e90496 | |
| author | markingmyname | |
| ms.author | maghan | |
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
ISSCommandWithParameters exposes support for [!INCLUDEssNoVersion] XML and user-defined types (UDT). This is 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 themselves will not 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