Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BitShift
Yak Posting Veteran
98 Posts |
 Posted - 2009-01-15 : 13:55:11
|
| I am looking for a way to pass multiple strings back to a stored procedure. Its much easier if your trying to pass integers, because you can just pass a comma-seperated list. Im thinking the best way to go is make the parameter that needs to accept a list as an xml datatype and then use xquery to get the list for use in the main query. suggestions ? |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2009-01-15 : 14:15:12
|
The common practice on passing a large set of variables to a stored procedure is to create a table and populate, then referance in the procedure, or declaring multiple input variables and populate each one. All other methods are really not recomended.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
 |
|
|
|
|
|
passing multiple string values to a sproc