FOR XML Workshop

• FOR XML Workshop 1

This article shows several examples that generate XML output using FOR XML along with AUTO and RAW.

•  FOR XML Workshop 2

Explains the PATH directive and shows a few examples using FOR XML with PATH to generate XML output using TSQL.

• FOR XML Workshop 3

Explains the EXPLICIT directive and shows several examples that generates XML output using FOR XML with EXPLICIT.

• FOR XML Workshop 4

A lab that generates an XML tree (hierarchy) using FOR XML EXPLICIT.

• FOR XML Workshop 5

Another lab that shows a few XML shaping examples using FOR XML PATH and FOR XML EXPLICIT

•  FOR XML Workshop 6

A lab that generates an RSS 2.0 feed using TSQL keyword FOR XML with PATH (SQL Server 2005)

Contact me for comments/suggestions/feedback.