May 24, 2002 at 8:51 am
Is there a array like construct in SQL Server,
if not, how can i do array like manipulation,I am using UDF.
like I have a set of values
thruough which i want to loop through
can this be done?
May 24, 2002 at 9:40 am
There is no array construct in SQL, but there is a table datatype, which is similar.
If you are looping, you are not really using SQL, instead, you would want to process teh entire result as a set. Usually.
Steve Jones
May 24, 2002 at 11:45 am
quote:
There is no array construct in SQL, but there is a table datatype, which is similar.
Applies to SQL 2000 only.
You can use #temp.tables instead to hold your values and manipulate them either as the whole recordset or loop thru by record.
Edited by - EPol29 on 05/24/2002 11:51:10 AM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply