Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags XML, String Manipulation Rss

   Items 1 to 5 of 5   

Converting String Data to XML and XML to String Data

In general XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data within. This is fine, but can cause some odd problems, such as ' entitization'. What do you do if you need to preserve the formatting? As usual Rob Sheldon comes to our aid.   Read more...
By Additional Articles 2012/02/07 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 3,971 reads

Split string using XML

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.  Read more...
By Divya Agrawal 2009/06/25 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 11,235 reads

Create a single string from an entire table

I have a need to pass an entire table of data as a parameter to a COM+ component. I found that a simple XML call did the job.  Read more...
By Mike Bennett 2008/09/15 | Source: | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 452 reads

Using XML to Enhance the Performance of String Manipulations

This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.  Read more...
By Wayne Sheffield 2008/08/20 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 9,517 reads

XML Workshop XII - Parsing a delimited string

Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.  Read more...
By Jacob Sebastian 2007/12/05 | Source: | Category: xml
Rating: |  Discuss |   Briefcase | 6,748 reads
   Items 1 to 5 of 5   
cross apply (1)    
split string (1)    
xquery (1)