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