Home > Store

XML and SQL Server 2000

Register your product to gain access to bonus material or receive a coupon.

XML and SQL Server 2000

Premium Website

  • Sorry, this book is no longer in print.
Not for Sale

Description

  • Copyright 2002
  • Edition: 1st
  • Premium Website
  • ISBN-10: 0-7357-1112-7
  • ISBN-13: 978-0-7357-1112-9

XML and SQL Server 2000 will enable SQL developers to understand and work with XML, the preferred technology for integrating eBusiness systems. This book will provide 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.

Downloads

Downloads

Click below for Downloads related to this title:
0735711127.zip (23k)

Sample Content

Downloadable Sample Chapter

Click below for Sample Chapter related to this title:
0735711127.pdf

Table of Contents



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.

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership