How Can I Create an Array in a Stored Procedure

[rr3news]

May I an Array variable in a Stored Procedure ?
If is possible, my i create a stored procedure tha returns an Array?

I Use SQL Server 2000.
Thank

 

[mrdenny]

SQL Server doesn't support arrays. You have to use a temp table or table variable. temp tables and table variables can not be used in input or output paramaters in a stored procedure.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com