Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
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