UNKNOWN --************************************** -- Name: Perform array-like manipulations using the set-oriented SQL features -- Description:How to perform array-like manipulations using the set-oriented SQL features -- By: Umachandar -- -- -- Inputs:None -- -- Returns:None -- --Assumes:None -- --Side Effects:None --This code is copyrighted and has limited warranties. --Please see http://www.Planet-Source-Code.com/xq/ASP/txtCodeId.188/lngWId.5/qx/vb/scripts/ShowCode.htm --for details. --************************************** 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