HnD | Passing array to stored procedure call, Page 1

Passing array to stored procedure call

Posts

rracer99
User

Posts: 58
Joined: 11-Mar-2007

# Posted on: 24-Jul-2008 12:32:49

Is it possible to pass an array of unknown size (runtime) to a MSSQL stored procedure ?

We have a complex database-side series of operations that need to occur and need to pass many (1,000+) GUID's to the sproc. What is the best way to handle this?

Walaa
Support Team

Posts: 14994
Joined: 21-Aug-2005

# Posted on: 24-Jul-2008 14:58:18

Either pass an XML string of values, or a string of comma separated values.

Please check out this link