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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-13 : 08:56:56
|
| Naveen writes "How can i return a array from a procedure?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-11-13 : 09:38:59
|
| Typically, stored procedures produce rowsets, output parameters and return values. You could build a CSV to simulate an array and return that as an output parameter. However, usually I try to avoid square-pegging round holes, so I return rowsets since an 'array' is a foreign concept to RDMBSs.Jay White{0} |
 |
|
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2002-11-13 : 15:54:10
|
| If you are using ADO to connect to SQL Server you can use the .GetRows method of the ADO Recordset to stuff all your results into an array. This is supposed to be a more effecient way of working with your results too as it implicitly closes (from what I've heard) your connection to the database (for the recordset).Kyle HeonPixelMEDIA, Inc.Senior Application Programmer, MCPkheon@pixelmedia.com |
|
|
|
|
|
|
Returning an Array