XML and SQL Server 2000
- Main Page
- Table of content
- Copyright
- About the Author
- About the Technical Reviewers
- Tell Us What You Think
- Introduction
- Who Will Benefit from This Book?
- Who Is This Book Not For?
- The Organization of This Book
- Chapter 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
- 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
- ExampleAn Enterprise Quarterly Fiscal Report
- Recap of What Was Discussed in This Chapter
- 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
- 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
- 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
- Chapter 6. Using XPath Queries
- Implementation Limitations
- Differences from W3C Specification
- XPath Data Types
- XPath Conversions
- Location Paths
- Accessing Database Objects via HTTP
- Recap of What Was Discussed in This Chapter
- Chapter 7. FOR XML
- Syntax
- FOR XML Limitations
- RAW Mode
- AUTO Mode
- EXPLICIT Mode
- Recap of What Was Discussed in This Chapter
- 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