O'Reilly logo

MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 by Thomas Moore

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required