Dose sqlserver 2000 support Array type?

Any one know about it?NO|||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
|||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.|||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.|||

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

|||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