Chapter 41. Using XML in SQL Server 2000
by Alex T. Silverstein and Paul Bertucci
IN THIS CHAPTER
Creating a Virtual Directory for Use with SQL Server 2000
Exploring Extensible Markup Language (XML)
Retrieving Data Using the FOR XML Clause
Using FOR XML RAW
Using FOR XML AUTO
Using FOR XML AUTO, ELEMENTS
Using FOR XML EXPLICIT
Retrieving XML-Data Schemas
Retrieving Binary Data in XML
The Basics of XML Path Language (XPath)
Using XML in Stored Procedures
Using OPENXML to Read XML
Using URL Queries
Using XML Templates
Using XML Updategrams
One of SQL Server 2000's major enhancements is the inclusion of native XML support, enabling developers to execute queries that return results as XML-formatted data, rather than standard rowsets. XML is quickly becoming the ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.