Chapter 4. Supporting the XML Framework

Terms you’ll need to understand:

  • ✓ Extensible Markup Language (XML)

  • ✓ XML schema definition (XSD)

  • ✓ XQuery

  • ✓ XML document

  • ✓ Schema

  • ✓ Element

  • ✓ Attribute

  • ✓ Node

  • ✓ FOR XML

  • ✓ ELEMENTS

  • ✓ XSINIL

  • ✓ value()

  • ✓ nodes()

  • ✓ query()

  • ✓ exist()

  • ✓ modify()

  • ✓ replace value of

  • ✓ insert

  • ✓ delete

  • ✓ XML index

Techniques you’ll need to master:

  • ✓ Writing queries that return XML

  • ✓ Using the xml data type

  • ✓ Using xml data type methods

  • ✓ Creating XML indexes

The language of business communication, in particular between data storage systems, is Extensible Markup Language (XML). SQL Server 2005 leverages XML with many features that implement XML functionality. This chapter looks at the breadth of XML coverage within the application. You can expect XML coverage ...

Get MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 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.

Start your free trial