This property is available on ADO.NET and ADO connection type in execute SQL task.
By default value of this property is False.
If we select other than ADO.NET and ADO then, in this case, this property will be disabled.
It confirms, the specified SQL statement is stored procedure or not. This property is editable only if the specified connection is ADO or ADO.NET, otherwise, the property is disabled only and the default value will be, “False”.
|
Connection type
|
IsQueryStoredProcedure
|
SQL Statement
|
|
ADO
|
FALSE
|
EXEC SP_NAME?,?(parameter)
|
|
ADO
|
TRUE
|
SP_NAME ?,?
|
|
ADO.NET
|
FALSE
|
EXEC SP_NAME @Param1,@param2
|
|
ADO.NET
|
TRUE
|
Procudername @param1,@param2
|
