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 03, 2005 4:25 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:02 AM
Points: 138, Visits: 259
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lPeysakhovich/manipulatingdataintexttypecolumns.asp


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


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 30, 2012 1:23 PM
Points: 290, Visits: 44
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 09, 2005 3:41 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, September 01, 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 07, 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