Post reply

Handling The Text Data Type

  • March 27, 2009 at 2:12 pm

    #967736

    Thanks for posting that. I noticed the same thing but thought I had missed something.

    Any idea what the alternative is? I expect using SUBSTRING.

  • May 4, 2009 at 1:02 am

    #987950

    Well done, Robert!

    Thanks for sharing your knowledge - it really saved when working on a clients' old SQL 2000 Server!

  • October 11, 2010 at 3:07 pm

    #1235225

    Hi

    Thank you so much for this very informative article.

    I have been trying to analyze the windows registry with SQL Server and found some lines to be over 60 thousand characters long!

    I would like to chop the long lines into 2000 character segments and put it into a new table with the original rowID, segmentID, and the 2000 characters in a varchar field.

    With what you've shown I think it will work.

    Thanks so much!!

    Conrad

Viewing 3 posts - 16 through 17 (of 17 total)

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