Discussion in 'SQL Server 2008 General Developer Questions' started by raviatvns, Aug 8, 2011.
I want to pass an arrayList for a single value in a stored procedure.
pls suggest some methods.
Welcome to the forum!
See if this helps: http://sommarskog.se/arrays-in-sql.html
Have you heard about Table Valued Parameters(TVP)?
...moreover I would like know whether you need it in SQL 2008 or earlier versions?
I guess the OP is posted in 2008 and using it. If the version is prior to 2008, TVP wont be available
Its only a guess... we can never under estimate the new members posting, without looking at forum section they might update the thread .
Separate names with a comma.