November 11, 2003 at 5:39 am
How do I accept an array as a input parameter in a sql stored procedure. Basically what I am trying to do is that I have a sql query in a stored procedure as
select * from P_Trade where TypeId IN(@Typeid)
TypeId is a integer type column in the database and from the code I am passing @Typeid as varchar(100) as its value can be
Request.form("Type") which returns 100,101,102
but when I execute the query in sql it gives a error like Typeid cannot be converted to varchar from int
The other way I think would be to use an array and pass it to the stored procedure but then how do I retrieve the value of this dynamic array in the stored procedure
Thanks.
November 11, 2003 at 5:44 am
I suggest this onr for reading http://www.algonet.se/~sommar/arrays-in-sql.html
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 11, 2003 at 6:17 am
select *
from P_Trade
where charindex(','+cast(TypeId as varchar)+',',','+@Typeid+',') > 0
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy