| XML and SQL Server 2000 |
| By John Griffin |
| | |
| Publisher | : New Riders Publishing |
| Pub Date | : July 20, 2001 |
| ISBN | : 0-7357-1112-7 |
| Pages | : 384 |
| | 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 |