Providers that support parameters must support ICommandWithParameters. Any provider that returns DBPROPVAL_SQL_ANSI92_INTERMEDIATE or DBPROPVAL_SQL_ANSI92_FULL for the DBPROP_SQLSUPPORT property can support parameters.
This optional interface encapsulates parameters. Parameters are scalar values, or a vector of scalar values, typically expressed in predicates but possibly supported by many providers in any scalar expression.
For scalar parameters of prepared commands, there is a presumption that different parameter values do not require different plans. In other words, a single preparation and its resulting plan are satisfactory for all possible values of scalar parameters.
Parameter values are set when a command is executed. Methods are included here to offer a means for setting and obtaining a list of parameters and their types.
| Method | Description |
| GetParameterInfo | Gets a list of the command’s parameters, their names, and their types. |
| MapParameterNames | Returns an array of parameter ordinals when given named parameters. |
| SetParameterInfo | Specifies the native data type of each parameter. |