Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: Array in SQL Server

    How would one implement an array in SQL Server ?

    Specically, i'm parsing a field into the array, and doing operations on these elements.

    Thanks.

  2. #2
    Join Date
    Jan 2004
    Posts
    13

    Cool

    use a temp table instead?
    no need to panic - its just 1's and 0's

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You can't....

    BUT! If you buy Ken Henderson's book:

    "The Guru's Guide to SQL Server Stored Procedures, XML, and HTLM"

    Chapter 26 discusses how to fake it out....

    http://www.sqlteam.com/store.asp
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    come on brett .. why dont you share your knowledge ...

    and btw ... i am desperately trying to secure a copy of that book
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by Enigma
    come on brett .. why dont you share your knowledge ...

    and btw ... i am desperately trying to secure a copy of that book
    I never did it...had no need, and with table variables it's a breeze....

    BUT...I should play with it, just from a learning experience (always move forward, no?)

    It entails creating and registering dll's and the like...

    I think all the ciode is on the cd that come with the book...

    and if you don't have this book, you should by it now, and read it cover to cover...sleep with it...take it out to a hockey game...whatever...

    just get it


    There are like 6 array function that Ken builds....they let you create, set, get, list, determine the length and destroy the array

    He does make mention that you have to be careful...failing to destroy the array will make memory unavailable to the server...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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