Professional Web Applications Themes

arrays in tsql ? - Microsoft SQL / MS SQL Server

Hi, is it possible to declare an array variable in tsql ? something lite Myvar1(100) and Myvar2(10,100). If, not, any workarounds to handle many variables ? (I've tried to write the code in a VB-script, but it was to slow). /J...

  1. #1

    Default arrays in tsql ?

    Hi,

    is it possible to declare an array variable in tsql ?
    something lite Myvar1(100) and Myvar2(10,100). If, not,
    any workarounds to handle many variables ?
    (I've tried to write the code in a VB-script, but it was
    to slow).

    /J
    jerome Guest

  2. #2

    Default Re: arrays in tsql ?

    http://www.aspfaq.com/2248



    "jerome" <com> wrote in message
    news:0ec301c367f3$d4061c70$gbl... 


    Aaron Guest

  3. #3

    Default Re: arrays in tsql ?

    [posted and mailed, please reply in news]

    jerome (com) writes: 

    CREATE TABLE #myvalues (ix int NOT NULL PRIMARY KEY,
    value <whatever> NOT NULL)
    --
    Erland Sommarskog, SQL Server MVP, se

    Books Online for SQL Server SP3 at
    http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
    Erland Guest

Similar Threads

  1. TSQL OR NOT TSQL this is the ?
    By Simon in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: August 2nd, 09:08 AM
  2. TSQL Query
    By Rayan in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 17th, 12:48 PM
  3. Is it possible to do this using TSQL instead of cursor ??
    By Ricky in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 7th, 05:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139