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) |
|