Chapter 10. Introduction to XQuery on SQL Server

Michael Coles

Starting with SQL Server 2005, Microsoft added built-in support for XML Query Language (XQuery). XQuery allows you to query your XML (Extensible Markup Language) data using a simple, yet powerful, path-style syntax. XQuery support makes it easy to

  • Retrieve XML elements from XML content
  • Extract scalar values from XML data
  • Check for the existence of elements or values in XML data
  • Modify your XML data via XML Data Manipulation Language (XML DML) extensions

SQL Server 2008 includes XQuery support with some slight improvements over the SQL Server 2005 release. This chapter is designed as an introduction to the XQuery functionality available in SQL Server. In this chapter we will assume ...

Get SQL Server MVP Deep Dives 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.