multi-input select statement RRS feed

  • Question

  • I'm trying to remeber how to set up a stored procedure to accept mutiple line input parameters.  For example, I want to be able to do the following:

    Select *
    From Table

    Where Column in ('Value 1', 'Value 2', 'Value 3', ... , 'Value N')


    The thing is I need to pass in 'Value 1' thru 'Value N' from my VB.NET app.

    Monday, October 22, 2007 8:06 PM


All replies