T-SQL Arrays

[rkbnair]

In T-SQL can I create an array to hold some say, 10 values?

Or is there any alternative methods?

Thanks

[deepak]

You cannot.
TSQL does not support arrays.
Alternately, you can store number values in a string and separate them and
convert them.
Or, Use the same variable in a loop if that helps.
Deepak.

"rkbnair" <rkannale@solus1.oceaneering.com> wrote:
>
>In T-SQL can I create an array to hold some say, 10 values?
>
>Or is there any alternative methods?
>
>Thanks
>

[Neil Pike]

You can't - you have to use a table

> In T-SQL can I create an array to hold some say, 10 values?
>
> Or is there any alternative methods?
>
> Thanks
>

Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (428 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7
- SQL Public)
or www.ntfaq.com/sql.html
or www.sql-server.co.uk
or www.mssqlserver.com/faq