Chapter 6. XML and the Relational Database

Stephen Forte

Since it appeared on the world scene in 1998, Extensible Markup Language (XML) has become quite a useful standard for exchanging data and documents between different systems. XML is a markup language (derived from Standard Generalized Markup Language, or SGML) for documents that contain structured information.

You might be wondering why you would want to store and work with XML in the database. Isn’t that what XML parsers and applications are for? Until now, XML was usually derived from database tables and queries and then programmatically placed into a transport format (such as a physical document or a Web service), parsed, read on the receiving end, and then placed in another database. ...

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.