passing multiple values in a string paramater to a stored procedure


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: passing multiple values in a string paramater to a stored procedure

Hybrid View

  1. #1
    Robert LaTraille Guest

    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.

  2. #2
    DaveSatz Guest

    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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center