April 2006
Intermediate to advanced
1088 pages
24h 51m
English
Content preview from A Developer’s Guide to SQL Server 2005Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
10. XML Query Languages: XQuery and XPath
XML BRINGS WITH it some powerful query languages for dealing with the hierarchical format that is typical of an XML document. This chapter covers XQuery from the perspective of its definition in a series of W3C standards. After looking at the standards, we describe the SQL Server 2005–specific implementation of the XQuery standards. The implementation consists of five SQL Server–specific methods on the XML data type that use XQuery to allow you to query or mutate XML data.
What Is XQuery?
In Chapter 1, we describe the components and uses of XML, and in Chapter 9, we cover the XML native data type in SQL Server 2005. The XML data type typically is a complex type—that is, a type that almost always contains ...