Dose sqlserver 2000 support Array type?

Any one know about it

Shoff
Can't you just use a table with one column as an array You could create a table variable in this way that would act like an array, maybe add an identity column which would be your index, and the second column would be your data column. This is not an array, but can be used like one, for example you could iterate through it with a cursor or a while loop.
Aaron Firouz
You can use this function I posted some time ago:

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=320221&SiteID=1

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
BarrySo
No, there is none (builtin) Sure you can define your own type with the new SQL Server 2005 but there is array type.

HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---
curiousbeginner
NO
kotte
Alternatively, use a large varchar, and biuld a string of your array elements, delimitering them with a set char, then use a while loop and CHARINDEX() to iterate through the elements.
john thom

There is no array type. Some of the other posters mentioned the work-arounds.

We'd be grateful if you could take a few moments and tell us what you're trying to do.

Thanks
Dose sqlserver 2000 support Array type?