Summary

At this point, your SQL Server 2000 XML toolbox should be just about full. The neat thing is that SQL Server 2000 is only the first version of SQL Server with native XML support. Now more than ever, with the advent of Web Services, Windows XP, the .NET Framework, and other emerging standards, the path to the future is paved with XML. SQL Server 2000 and the techniques illustrated here will help you find your way along it.

In the next chapter, you'll learn about Microsoft SQL Server Analysis Services, a powerful set of tools for data mining and analytical processing.

Part I: Welcome to Microsoft SQL Server

Part II: SQL Server Tools and Utilities

Part III: SQL Server Administration

Part IV: Transact-SQL

Part V: SQL Server Internals and Performance Tuning

Part VI: Additional SQL Server Features

Chapter 41. Using XML in SQL Server 2000

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

Chapter 42. Microsoft SQL Server Analysis Services

Chapter 43. Microsoft Transaction Server

Chapter 44. SQL Server Full-Text Search Services

Chapter 45. SQL Server Notification Services

Chapter 46. SQL Server and the Microsoft .NET Framework

Chapter 47. English Query