Querying XML Data Using XQuery
Storing XML in the database is one thing; querying it efficiently is another. With SQL Server 2000, which has no xml data type, you had to deconstruct the XML and move element and attribute data into relational columns to perform a query on the XML data residing in the text column. You could also resort to some other searching mechanism, such as full-text search. In SQL Server 2005 and 2008, XQuery provides a native and elegant way to query XML data.
Understanding XQuery Expressions and XPath
XQuery is a language used to query and process XML data. XQuery is a W3C standard; its specification is located at http://www.w3.org/TR/xquery/. The XQuery specification contains several descriptions of requirements, use cases, ...