SQL Server 2005 XQuery and XML-DML
The topics we’ll be covering in this article are: A brief overview of the way that SQL Server 2005 stores XML documents and schemas, How SQL Server 2005 provides support for querying and manipulating XML documents, A simple test application that allows you to experiment with XQuery. In two subsequent articles, we'll see some techniques for improving the performance of applications that work with XML documents, as well as some examples of the different ways you can use XQuery.
What’s New in SQL Server 2005 XML
In this article, author Hilary Cotter discusses the new SQL Server 2005 XML feature, including the XML data type, the ability to query XML data stored in the XML data type using XPath or XQuery statements, the ability to issue DDL statements against XML documents stored in the XML data type, and the ability to index XML documents.
XML Queries and Indexing in SQL Server 2005
For the first time, SQL Server 2005 offers a native XML data type. See how you can store and query XML documents as part of a SQL Server table, and how to use XML indexes to make queries against these columns more efficient.
Enterprise Open Source Journal Enterprise Open Source Journal is the first magazine designed solely to focus on open source strategies in the enterprise.
subscribe now
