November 3, 2005 at 4:25 pm
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/manipulatingdataintexttypecolumns.asp
December 7, 2005 at 4:25 pm
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
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
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply