Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameter for IN ( '...', '...' )
Message
From
05/06/2007 07:18:49
Aman Bains
Jaguar Computers
Jalandhar, India
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Parameter for IN ( '...', '...' )
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01230497
Message ID:
01230497
Views:
53
How do I send parameter to a stored procedure which expands to ['222','333']
create procedure getMyVal @cPara varchar(50)
as
select * from <ctable> where id in (@cPara)
calling
cPara= "'222','333'"
sqlexec(nHandle,"exec getMyVal ?cPara")
I am not able to send an InList equivalent string to SQLserver SP. I want the parameter to contain something like '222','333' so that IN Clause works on multiple values.
Can it work? Is there another way?
Aman
-------
Lets fly away to the Land where there is Love & Peace
Next
Reply
Map
View

Click here to load this message in the networking platform