-
passing multiple values in a string paramater to a stored procedure
Can anyone help me with the syntax to pass multiple values to a stored procedure
that uses a defined variable, ie. I want to pass multiple numbers to a
stored procedure that has a defined field for a number variable. @AgentID
pass a list of numbers to that variable in the stored procedure to return
a recordset.
-
Re: passing multiple values in a string paramater to a stored procedure
this FAQ should provide you with 3 alternatives:
http://www.mssqlserver.com/faq/development-array.asp
"Robert LaTraille" <rlatraille@tdirect.com> wrote in message
news:3a3156a4$1@news.devx.com...
>
> Can anyone help me with the syntax to pass multiple values to a stored
procedure
> that uses a defined variable, ie. I want to pass multiple numbers to a
> stored procedure that has a defined field for a number variable. @AgentID
> pass a list of numbers to that variable in the stored procedure to return
> a recordset.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|