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"
