Murach's SQL Server 2005 for Developers
How to work with XML

This chapter shows you how to use new and enhanced features of SQL Server 2005 to work more easily than ever with XML data.
Chapter 18 How to work with XML
An introduction to XML 550
An XML document 550
An XML schema 552
How to work with the xml data type 554
How to store data in the xml data type 554
How to work with the XML Editor 556
How to use the methods of the xml data type 558
An example that parses the xml data type 562
Another example that parses the xml data type 564
How to work with XML schemas 566
How to add an XML schema to a database 566
How to use an XML schema to validate the xml data type 568
How to view an XML schema 570
How to drop an XML schema 570
Two more skills for working with XML 572
How to use the FOR XML clause of the SELECT statement 572
How to use the OPENXML statement 576
Perspective 578
t


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2005

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.