I am implementing a multi-variable search SP to which I need pass single
values and arrays as arguments, e.g.
exec mySP 'abc', {3,5,8}, 'en-US', {4,5}, ... etc
How to pass the args to mySP and how to retrieve the values from the arrays
inside the SP?
TIASee if these examples help:
http://vyaskn.tripod.com/passing_ar..._procedures.htm
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"alto" <altodorov@.hotmail.com> wrote in message
news:OonW%237G7FHA.2676@.TK2MSFTNGP15.phx.gbl...
> I am implementing a multi-variable search SP to which I need pass single
> values and arrays as arguments, e.g.
> exec mySP 'abc', {3,5,8}, 'en-US', {4,5}, ... etc
> How to pass the args to mySP and how to retrieve the values from the
arrays
> inside the SP?
> TIA
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment