Is It possible to do arrays in sql
i need to do a stack when reading from a table using a cursor
to deal with tree data.

hope some one help About arrays In SQL

Ahmed Ali
Software Developer

__________________
Ahmed Ali
Senior Software Developer

Hello,

There is a table variable, which you can insert contents into this table variable

declare @t table
(
  myID int identity(1,1) primary key not null,
  text varchar(50) not null
)

I don't believe you can do arrays. Maybe in SQL 2005, but I'm not sure then. I haven't seen any specs on it...

Brian

No insure there in no Array in MS-SQL!
what is array at all?! u can make a dumy table as Brian said & work with that, as an array do for!

Always:),
Hovik Melkomian.

Though you are using MSSQL 7, still you can insert those values into a temp table and process from there are as Brian said. Why should one keep longing for arrays in SQL;) when there is an alternate?

_________________________
-Vijay G
Strive for Perfection