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

This chapter shows you how to use the xml data type and other SQL Server features that make it easy to work with XML data.
Chapter 18 How to work with XML
An introduction to XML 584
An XML document 584
An XML schema 586
How to work with the xml data type 588
How to store data in the xml data type 588
How to work with the XML Editor 590
How to use the methods of the xml data type 592
An example that parses the xml data type 596
Another example that parses the xml data type 598
How to work with XML schemas 600
How to add an XML schema to a database 600
How to use an XML schema to validate the xml data type 602
How to view an XML schema 604
How to drop an XML schema 604
Two more skills for working with XML 606
How to use the FOR XML clause of the SELECT statement 606
How to use the OPENXML statement 610
t


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

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



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.