set quoted_identifier on
set nocount on
go
declare @x smallint
create table #array("index" smallint, value smallint)
select @x = 0
while @x < 8
begin
insert #array values(@x, @x)
select @x = @x + 1
end
-- Array[3] is
select value from #array where "index" = 3