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, ...

Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.