Post reply

Manipulating Data in TEXT Type Columns

  • December 7, 2005 at 4:25 pm

    #608302

    Man! This is the first time I've EVER heard anyone say "For many SQL Server 2000 DBAs working with text columns in T-SQL is no different than any other datatype." Lol!

    Great article though, thanks.

    John Scarborough
    MCDBA, MCSA

  • December 9, 2005 at 3:41 pm

    #608837

    Agreed, TEXT datatypes are like other datatypes as chalk is like cheese.

    However interesting article, a shame it was hard work to read.

  • December 7, 2006 at 7:17 am

    #676589

     

    Great article.

    But it looks like there is an error in a code.

    If XML tag happens start right before position 8000 (or multiple of) it will not be found.

    This may be a fix:

    Set @parsedlen = @parsedlen + 8000 - len(@parsedval)+1

     

Viewing 3 posts - 1 through 4 (of 4 total)

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