Hi Ben,

Thanks for response....I am really sorry that I haven't explained here
properly....I trying to pass multiple input parameters from Direct SQl to
stored proc

EXEC databasename.dbo.storedproc name $"ChangeID"$

in the above execute condition is it possible to send multiple input
parameters or does any one have any idea.....


Benny Shell wrote:
> 
> I'm a little confused..  The you can pass any number of parameters to the
> stored procedure in the SQL statement you use to call it, ,just substitute
> the field names in the text of the SQL call.
> 
> On Fri, Aug 19, 2011 at 10:49 PM, gok's <[email protected]> wrote:
> 
>> Hi ALL,
>> ARServer 7.5
>> Database:SQL 2005 sp2
>> Windows NT
>>
>> I am trying to pass multiple input parameters to a stored procedure but
>> is
>> it possible to pass multiple parameters...can some one suggest me.
>>
>> Thanks
>> G
>>
>> --
>> View this message in context:
>> http://old.nabble.com/How-can-I--pass-multiple-input-parameters-in-direct-SQL-tp32299660p32299660.html
>> Sent from the ARS (Action Request System) mailing list archive at
>> Nabble.com.
>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>
> 
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
> 
> 

-- 
View this message in context: 
http://old.nabble.com/How-can-I--pass-multiple-input-parameters-in-direct-SQL-tp32299660p32316180.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Reply via email to