Module 2: Retrieving XML Data
This module provides students with an introduction to the FOR XML clause.
After completing this module, students will be able to:
Generate Extensible Markup Language (XML) from Microsoft® SQL
Server™ data by using the RAW and AUTO modifiers.
Use the Elements option to return an element-centric XML document.
Use Table and Column aliases to name the returned elements and attributes.
Create XML documents containing data from multiple tables by using
JOIN statements.
Generate an XML document with a custom structure by using the
EXPLICIT modifier....