Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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,629 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,086 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 | 449 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,482 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,697 reads
   Items 1 to 5 of 5   
cross apply (1)    
split string (1)    
xquery (1)