---

XML and SQL Server 2000

ISBN: 0735711127
EAN: 2147483647

Year: 2005
Pages: 104

Authors: John Griffin

BUY ON AMAZON

• 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