SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags XML, FOR XML PATH Rss

   Items 1 to 2 of 2   

Basics of XML and SQL Server, Part 1: Streaming XML

This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.  Read more...
By Stan Kulp 2012/03/07 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 7,028 reads

Generating a Distinct Delimited List Using XML

Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.  Read more...
By Puja Shah 2010/06/29 | Source: SQLServerCentral.com | Category: for xml path
Rating: |  Discuss |   Briefcase | 7,293 reads
   Items 1 to 2 of 2   
bulk insert (1)    
row_number() (1)    
xhtml (1)    
xslt (1)