Manipulating Data in TEXT Type Columns

Question

Manipulating Data in TEXT Type Columns

Leo Peysakhovich

Hall of Fame

Points: 3973
More actions
November 3, 2005 at 4:25 pm

#166618

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/manipulatingdataintexttypecolumns.asp

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

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

John Scarborough Ten Centuries Points: 1104 More actions · Answer 1

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

Stuart Davis Old Hand Points: 342 More actions · Answer 2

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

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

Dmitry Korsunsky Valued Member Points: 56 More actions · Answer 3

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

Manipulating Data in TEXT Type Columns

Cookies on SQLServerCentral