Advancements such as the native XML data type and XQuery help you seamlessly connect internal and external systems. Microsoft SQL Server 2005 supports relational and XML data natively, so you can store, manage, and analyze data in the format that best suits your needs.
Introduction to XQuery in Microsoft SQL Server 2005
Get an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features.
Articles and Columns
Overview of Native XML Web Services for Microsoft SQL Server 2005
Get an overview of how to set up and use XML Web Services using SOAP/HTTP inside SQL Server 2005. Illustrative examples are included. To get the most from this paper, you should have a basic understanding of Web service technologies including HTTP, SOAP, and WSDL.
Performance Optimizations for the XML Data Type in SQL Server 2005
Learn about performance optimizations for the XML data type in SQL Server 2005. This paper covers several ideas to improve query and data modification performance of XML data type in SQL Server 2005. To get the most value from this paper, you need familiarity with the XML features in SQL Server 2005
Processing XML Showplans Using SQL CLR in SQL Server 2005
Build an application to extract a query's estimated execution cost from its XML showplan. Users can submit only those queries costing less than a predetermined threshold to a server running SQL Server 2005, thereby ensuring it is not overloaded with costly, long-running queries.
XML Best Practices for Microsoft SQL Server 2005
Get the latest guidelines for XML data modeling and usage in SQL Server 2005 to help you develop rich applications for semi-structured and unstructured data management.
XML Indexes in SQL Server 2005
Use the relational query engine in SQL Server 2005 to make a single query plan for the SQL and XQuery parts of your queries, and make the implementation of XML queries fast and easy to predict and tune.
XML Options in SQL Server 2005
Three options for handling XML data in the Visual Studio 2005/SQL Server 2005 environment are discussed, including usage scenarios and guidelines to help you choose between them.
XML Support in Microsoft SQL Server 2005
This article discusses the XML support built into SQL Server 2005. It shows how this support integrates with the client-side programming support in the .NET Framework 2.0 and in native code such as OLEDB and SQLXML.
What's New with FOR XML in SQL Server 2005
This article details the major new capabilities of the server-side FOR XML clause in the next version of SQL Server. These enable you to further enhance the XML support in your applications and to write easy-to-maintain relational data-to-XML aggregations.