SQL Parameters

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

You cannot pass an array into a procedure.

Here's an article you can read:

You can also try to pass in XML

Jim Dillon-291542 Hall of Fame Points: 3344 More actions · Answer 2

I always use #temp_tables to hold arrays for my stored procedures. There's probably a better way, but it does the trick.

G Money-291556 SSChasing Mays Points: 633 More actions · Answer 3

SSChasing Mays

Points: 633

July 14, 2006 at 7:42 am

Great article Ray

Thanks

robertk SSCommitted Points: 1608 More actions · Answer 4

Instead of an array of strings, or temp tables, pass in XML variables instead.

bledu SSChampion Points: 12335 More actions · Answer 5

i used an xml string sometime back and it did the trick for me

Everything you can imagine is real.