Passing in a Parameter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi All,

I have a Stored Proc and would like to pass in a VARCHAR parameter. The
problem is that the query will need to use it in a IN clause...

DECLARE @PARAM AS VARCHAR(20)
SET @PARAM = 'Dan', 'Mike', 'Lisa'

SELECT *
FROM Orders
WHERE Name IN (@PARAM)

is there a away around this?

Thanks,
Kunkel
.

Relevant Pages

  • Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
    ... > Then you can read the value of @total after closing the query. ... > 2 Set up your input param values. ... the result of this sql code returns an integer that is ... >> take the guts of the stored proc with hard coded guestid and meeting ...
    (borland.public.delphi.database.ado)
  • Re: Passing in a Parameter
    ... >I have a Stored Proc and would like to pass in a VARCHAR parameter. ... >problem is that the query will need to use it in a IN clause... ... >DECLARE @PARAM AS VARCHAR ...
    (microsoft.public.sqlserver.mseq)
  • RE: parameter in sql query
    ... Just set connection string to run it. ... > If the substition is before...the error seems to imply that the query is ... > being transferred to the sql server without the parameter being replaced ... > creating a datacomponent with a sql param, ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: using python to post data to a form
    ... """Factory function to create a post form query to submit on a html webpage. ... @param query - the query string from the existing query list of the query webpage. ... # the Password Manager will always use ...
    (comp.lang.python)
  • Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
    ... Then you can read the value of @total after closing the query. ... Set up your input param values. ... > take the guts of the stored proc with hard coded guestid and meeting code ...
    (borland.public.delphi.database.ado)