Passing multiple parameters of same column to SQL Server select SP

Posted by Bill on Stack Overflow See other posts from Stack Overflow or by Bill
Published on 2009-06-01T14:31:49Z Indexed on 2010/04/06 20:03 UTC
Read the original article Hit count: 211

I have a string value in the web.config — for example 2 guids seperated by a ",". I need to query the database dynamically (i.e i have no idea how many values could be seperated by a comma in the web.config) and run a select statement on the table passing these values and getting all that is relevant for example:

select * from tablename where columnname = string1 string2 string3 etc etc

some strings may only contain 1 guid some may contain 10

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about sql