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’