Using the SQL Server service instance ‘Use parameters for stored procedures' service key
KB003602
PRODUCTK2 Five
Use the following information to help you configure the ‘Use parameters for stored procedures’ service key of the SQL Server service instance. For more information see SQL Server Service Type.
| Key Condition | Description |
|---|---|
| True | When set to True, stored procedure parameters are added as Service Object method parameters and are tied to the method. All stored procedure parameters are added as optional or required parameters, and not as SmartObject properties. This allows for the parameter to be properly passed to the stored procedure call without the added property on the SmartObject for return results. |
| False | When set to False, the stored procedure parameter is returned as a property (typically as System.String[]). You generate SmartObject properties for all stored procedure parameters. This may, however, result in having SmartObject properties that do not return data. |
