SQL Server doesn't support array's within or outside of stored procedures.
The closest thing that SQL Server has would be a table variable. It's accessed just like a regular or temp table, but it's done mostly in memory.
<pre>DECLARE @TableVar TABLE
INSERT INTO @TableVar
SELECT 1, 2, 'test'
Last Wiki Answer Submitted: March 16, 2008 11:46 pm by Denny Cherry64,520 pts.