Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Manipulating Data in TEXT Type Columns Expand / Collapse
Author
Message
Posted Thursday, November 3, 2005 4:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 7:25 AM
Points: 138, Visits: 272
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/manipulatingdataintexttypecolumns.asp


Post #235034
Posted Wednesday, December 7, 2005 4:25 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:52 PM
Points: 290, Visits: 52
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
Post #242706
Posted Friday, December 9, 2005 3:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 1, 2010 5:23 AM
Points: 108, Visits: 23

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

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




Post #243359
Posted Thursday, December 7, 2006 7:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 25, 2011 6:40 AM
Points: 8, Visits: 20
 

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

 

Post #328742
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse