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.

Start your free trial