T-SQL Arrays


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: T-SQL Arrays

  1. #1
    rkbnair Guest

    T-SQL Arrays


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

    Or is there any alternative methods?

    Thanks


  2. #2
    deepak Guest

    Re: T-SQL Arrays


    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
    >



  3. #3
    Neil Pike Guest

    Re: T-SQL Arrays

    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center