New Transact SQL Video Tutorial: Pt. 1 - Using FOR XML Clauses in SQL Server

Pt. 1 - Using FOR XML Clauses in SQL Server - view details

The FOR XML clauses allow you to generate XML based on your SELECT statements. There are several different ways to generate XML - FOR XML AUTO, FOR XML RAW, FOR XML EXPLICIT, FOR XML PATH, and more. How do you know which to use? What's the difference between RAW and AUTO? Which of these can auto-detect relationships in the data?

Highlights from this video:

• An overview of the different FOR XML options
• When should I use FOR XML?
• Using FOR XML RAW
• USING FOR XML AUTO
• Changes in SQL Server 2005

and much more

---

• Source: http://www.LearnTransactSQL.com
• Category: XML and SQL Server - FOR XML, SQLXML, MSXML, and More
• Skill Level: 400 (Intermediate - Advanced)
• Length: 13:20 (9.8MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: sqlxml, msxml, sql xml, msxml4