SQLUNINTERRUPTED

With SQL Server 2000 and later versions of Microsoft SQL Server relational tables can be queries to produce XML output or XML documents can be converted to relational tables.

In this series of articles I will talk about SQL XML features in SQL Server 2000 and then Continue with XML enhancements in SQL Server 2005 and SQL Server 2008. Some of things which I will be talking about are

• Converting Relational Tables to XML documents using FOR XML RAW
• Converting Relational Tables to XML documents using FOR XML AUTO
• Converting Relational Tables to XML documents using FOR XML EXPLICIT
• Converting XML documents to Relational Tables using OPENXML
• XML Enhancements in Microsoft SQL Server 2005 and later versions
1. Working with FOR XML PATH mode in SQL 2005
2. NESTED FOR XML Queries with SQL Server
3. XML Data type and XML Data type Methods in SQL Server
4. XML Schema collections in SQL Server
5. Working with XML Indexes in SQL Server
6. Using XQuery expressions with XML in SQL Server 2005 and later