Tuesday, October 14, 2014

Uses of FOR XML

Generating XML (Funnily enough)
SQL Server - FOR XML Basics

Concatenation
Grouped Concatenation  using FOR XML PATH
TSQL – Concatenate Rows using FOR XML PATH()

Splitting Strings
Generating and Splitting a Delimited String Column

No comments: