New FOR XML Features

The FOR XML feature introduced in SQL Server 2000 is enhanced in SQL Server 2005, with both new features and updates to the existing functionality. For more information, see Constructing XML Using FOR XML.

The following topics describe the enhancements:

• TYPE Directive in FOR XML Queries
• RAW Mode Enhancements
• AUTO Mode Enhancements
• EXPLICIT Mode Enhancements
• Nested FOR XML Queries
• Generating Elements for NULL Values Using the XSINIL Parameter
• FOR XML Support for Various SQL Server Data Types
• Inline XSD Schema Generation
• Change in Inline XDR Schema Generation