sackerdj
SSC Eights!
Points: 815
More actions
May 24, 2002 at 8:51 am
#158459
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?
Steve Jones - SSC Editor
SSC Guru
Points: 728159
May 24, 2002 at 9:40 am
#429732
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
steve@dkranch.net
Follow me on Twitter: http://www.twitter.com/way0utwest Forum Etiquette: How to post data/code on a forum to get the best help My Blog: www.voiceofthedba.com
Eve
SSCrazy
Points: 2480
May 24, 2002 at 11:45 am
#429739
quote: There is no array construct in SQL, but there is a table datatype, which is similar.
quote:
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