array variable?

[sagn]

Are there array variables in SQL?

I'd like to set each element of an array
the value of a query. For example:

declare @array[10] varchar(50)

set @array = (select a from table1)


(this of course does not work)
Is this sort of thing possible?

thanks

dsag

 

[fluteplr]

Not that I am aware of. Why don't you just use a temporary table?

 

[sagn]

I didn't think so. Yes, I will use a temporary table
but I just thought arrays would be nice.

Thanks

sagn