Passing in a Parameter

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: 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)
  • Re: getting return value from stored proc
    ... | Dim param As New ADODB.Parameter ... | Dim cmd As ADODB.Command ... || parameters Run your stored procedure via command object: ... The stored proc then returns a value ...
    (microsoft.public.access.formscoding)
Quantcast