Chapter 41. Using XML in SQL Server 2000

by Alex T. Silverstein and Paul Bertucci


  • 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



  • 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 dominant format for passing data across networks and between diverse code components. With SQL Server 2000, XML can be passed into and returned from stored procedures, passed directly between SQL Server and the Internet, and much more. Developers also will be leveraging XML via ADO.NET, the full impact of which is discussed in Chapter 46, "SQL Server and the Microsoft .NET Framework." All in all, the .NET Framework is now capable of both XML via the ADO.NET layer and native XML support directly with SQL Server 2000. This chapter will introduce XML concepts and usage examples from SQL Server 2000's point of view. We will be using the Web (IIS) for much of the examples so it should be configured for use with SQL Server (if you haven't already done this).

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features