Professional Web Applications Themes

Store/retrive a string array to SQL Server - Microsoft SQL / MS SQL Server

http://www.aspfaq.com/2248 "Kyle Klaus" <net> wrote in message news:phx.gbl... ...

  1. #1

    Default Re: Store/retrive a string array to SQL Server

    http://www.aspfaq.com/2248




    "Kyle Klaus" <net> wrote in message
    news:phx.gbl... 


    Aaron Guest

  2. #2

    Default Store/retrive a string array to SQL Server

    Kyle:

    I see no reason to denormalize by putting multiple notes
    in a comma delimited list in the database. Another table,
    with one row per note, will probably give better
    performance, easier access (no need to p data for
    delimiters), no issues with the delimiter being a valid
    character within the string ...

    IMHO, don't denormalize if you don't have to.

    Vern
     
    7.0 as the 
    Notes, stored in 
    varrying number of 
    store this in my 
    to store the 
    varchar field with 
    had a potential 
    think of is to 
    element of the String 
    practice? 
    Vern Guest

  3. #3

    Default Re: Store/retrive a string array to SQL Server

    [posted and mailed, please reply in news]

    Kyle Klaus (net) writes: 

    The latter is definitely the way to go.

    To unpack a comma-separated list into a table,
    sehttp://www.algonet.se/~sommar/arrays-in-sql.html for various methods.


    --
    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. Question How to stored And Retrive pdf Doent in Asp.Net(C#) with Sql Server 2005
    By Vinod Ingle in forum Brainstorming Area
    Replies: 0
    Last Post: August 13th, 03:57 PM
  2. How to store objects in array and the retrieve them
    By J.P. in forum PHP Development
    Replies: 4
    Last Post: August 20th, 02:12 PM
  3. [PHP] How to store result in array for later display?
    By P Cuce in forum PHP Development
    Replies: 0
    Last Post: September 3rd, 01:31 PM
  4. Replies: 2
    Last Post: August 16th, 10:26 AM
  5. [PHP] Store array as Session Variable
    By Cpt John W. Holmes in forum PHP Development
    Replies: 9
    Last Post: July 29th, 04:19 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