Arrays in T-SQL?

[Waynest]

Hello all

Is it possible to use arrays of variables within a stored procedure, I dont seem to be able to locate anything in the online help. I was planning to create series of dates using a nested loop and the code is going to be ridiculously long if I cant use subscripts!

An example of syntax would be great if it is 'doable'.

TIA
Wayne

 

[tlbroadbent]

T-SQL doesn't have array variables. However, you can simulate arrays with comma separated variables (or another delimiter of choice.) See the following article.

http://www.sqlteam.com/item.asp?ItemID=637

If you have SQL 2000, you can use table variables to simulate arrays. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dvrobin]

Another possibility (at least for SQL 7) is to use a temp table. A local temporary table only lasts for the length of the current session and can be a good way to dump an array of values.

Dave Robinder, MCSD