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: 234
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