Post reply

Text data..storage

  • October 1, 2004 at 6:57 am

    #163423

    Hi,

    Im having 5 text colums of 2500 bytes each in a single table.

    I dont want to use text/image pages for storing the data.

    So whats the solution so that my inserts wont fail.

     

    this question was asked to me by MS guy during interview.

     

     

     

     

  • October 1, 2004 at 7:20 am

    #525016

    An obvious way is to break the text column up during the insert and insert one column into seperate table columns that are large enough to hold the data required.

    When you retrieve the data from the table put it back together again.

     

    There may be an easier method, but none that I can think of, off hand.

     

     

    ------------------------------
    The Users are always right - when I'm not wrong!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply