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

This page was last updated on May 01, 2006 04:28 PM.