Utilize the newly available XML capabilities found in SQL Server 2000.

XML and SQL Server 2000 will enable SQL developers to understand and work with XML, the preferred technology for integrating eBusiness systems. These developers have realized the need to be able to understand and work with high-speed storage and generation capabilities that XML documents and data offer. The pervasiveness of XML has finally caused the beginnings of the appearance of tools that allow easier manipulation of XML itself. SQL Server 2000 has added several new features that SQL Server 7 never had that make working with and generating XML easier for the developer. XML and SQL Server 2000 provides a comprehensive discussion of SQL Server 2000's XML capabilities. There is a brief discussion in the first two chapters on XSL/XSLT and DTD's targeted to database developers since most developers are new to this technology. From there, numerous examples are discussed in the areas of IIS Directories, http, XML views and XML schemas, openxml, and much more.

1. XML.

The Origin of XML. The XML Document. Document Type Definition (DTD). XML Schemas. Advanced Topics. Answers to the Two Exercises in the Chapter. Recap of What Was Discussed in This Chapter.

2. XSLT Stylesheets.

Extensible Stylesheet Language Transformations (XSLT). What Are Stylesheets? Nodes and Trees, Not Documents. Stylesheet Structure. Templates. Formatting Numbers for Output. Conditional Processing. Modes. Example-An Enterprise Quarterly Fiscal Report. Recap of What Was Discussed in This Chapter.

3. IIS and Virtual Directories.

Virtual Directories. The Virtual Directory Management Utility. Creating a Virtual Directory Using the Virtual Directory Management Utility. The Virtual Directory Management Object Model. Creating a Virtual Directory Using the Object Model. Recap of What Was Discussed in This Chapter.

4. Accessing SQL 2000 via HTTP.

Two-, Three-, and N-Tiered Architectures. What Are Our Capabilities When Utilizing HTTP? Entities. Executing SQL via HTTP. Executing Template Files via HTTP. Executing Stored Procedures. Accessing Database Objects via HTTP. Posting Templates via HTML Forms. Recap of What Was Discussed in This Chapter.

5. Creating XML Views with XDR Schemas.

Overview. XDR Schemas. BizTalk. Annotations to the XDR Schema. Default Values for Schema Attributes. Using Annotated XDR Schemas in Queries. Schema Caching and Performance. Recap of What Was Discussed in This Chapter.

6. Using XPath Queries

Implementation Limitations. Differences from W3C Specification. XPath Data Types. Location Paths. Accessing Database Objects via HTTP. Recap of What Was Discussed in This Chapter.

7. FOR XML.

Syntax. FOR XML Limitations. RAW Mode. AUTO Mode. EXPLICIT Mode. Recap of What Was Discussed in This Chapter.

8. OPENXML.

Using OPENXML. Metaproperties. Recap of What Was Discussed in This Chapter.

Appendix A. Northwind Database Schema.

Table Categories. Table CustomerCustomerDemo. Table CustomerDemographics. Table Customers. Table dtproperties. Table Employees. Table EmployeeTerritories. Table Order Details. Table Orders. Table Products. Table Region. Table Shippers. Table Suppliers.

Appendix B. XSLT Instructions with Reference to Text Usage.

Appendix C. XPath Functions and Examples.

Appendix D. Microsoft XML Data Types.

Appendix E. Resources.

XML. XSLT. Namespaces. XML Schema. SQL Server 2000. Miscellaneous Resources.

Appendix F. IBM's XSL Editor.

Appendix G. Microsoft's SQL Server XML View Mapper.

Overview of XML View Mapper. How XML View Mapper Works.

Glossary.

Index.