Hi Sean,
Thanks for response let me check using this.........in SQL
Garrison, Sean (Norcross)-2 wrote:
>
> I don't know about MS SQL but in Oracle you can do this (via direct SQL)
>
> BEGIN
> Stored_Procedure_Name('$Param1$', '$Param2$', ....);
> END;
>
> Where Param 1 and Param 2 are your fields from remedy.
> I am not familiar with MS SQL but I believe it does support BEGIN and END;
> blocks like Oracle does.
>
> Sean
>
> From: Action Request System discussion list(ARSList)
> [mailto:[email protected]] On Behalf Of benny shell
> Sent: Monday, August 22, 2011 11:01 AM
> To: [email protected]
> Subject: Re: How can I pass multiple input parameters in direct SQL
>
> ** 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]<mailto:[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<http://www.arslist.org>
> attend wwrug11 www.wwrug.com<http://www.wwrug.com> ARSList: "Where the
> Answers Are"
>
> _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-tp32299660p32316188.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"
