---

Programming Microsoft SQL Server(TM) 2000 with XML (Pro-Developer)

ISBN: 0735613699
EAN: 2147483647

Year: 2005
Pages: 89

Authors: Graeme Malcolm

BUY ON AMAZON

• Cover
• LOC
• Dedication
• Acknowledgments
• Introduction
• 1 - SQL, XML, and the Business Internet
• Relational Data and SQL
• The Challenge of Integration
• XML to the Rescue
• Web-Enabling a Business Using XML
• 2 - Retrieving XML Data Using Transact-SQL
• The SELECT...FOR XML Statement
• Using RAW Mode
• Using AUTO Mode
• Using EXPLICIT Mode
• Retrieving Binary Fields with the BINARY BASE64 Option
• Summary
• 3 - Using ADO for XML Data Access
• An ADO Refresher
• XML Query Templates
• Using ADO to Execute XML Queries
• XML-Related SQLOLEDB Provider Properties
• Summary
• 4 - Using HTTP for Data Access
• SQL Server HTTP Publishing Architecture
• Publishing a Database Through an IIS Virtual Directory
• Scripting Virtual Directory Configuration
• Using URL Queries to Test a Virtual Directory
• Summary
• 5 - Using XML Templates to Retrieve Data over HTTP
• What Is a Template?
• Creating Templates
• Applying Style Sheets with Templates
• Posting a Template
• Summary
• 6 - Retrieving Data with Mapping Schemas
• XML Schemas--An Overview
• Mapping Schemas
• Using a Mapping Schema to Retrieve Data
• Advanced Annotations
• Summary
• 7 - Inserting XML Data Using OpenXML
• A Model for Receiving XML Documents
• Generating Rowsets with the OpenXML Function
• Using OpenXML to Insert Data
• Using OpenXML to Retrieve XML Metadata
• Summary
• 8 - Additional XML Tools
• Installing the XML For SQL Server 2000 Web Release
• Modifying Data with Updategrams
• The XML Bulk Load Component
• Summary
• 9 - Building an E-Commerce Solution with SQL Server and XML
• The Sample E-Commerce Scenario
• The Online Retail Web Site
• Order Processing at the Supplier
• Viewing Delivery Information
• Updating the Catalog
• Invoicing the Retailer
• Summary
• Appendix - Introduction to XML
• What Is XML?
• Navigating XML Documents with XPath
• XSL Style Sheets
• XML Data Schemas
• Summary
• About the Author
• About This Electronic Book
• Create a List of Favorite Topics
• External Links
• Enlarge Graphics
• Use Accessibility Shortcut Keys
• Use the Shortcut Menu Commands
• To Turn On MouseKeys
• Customize the Help Viewer
• Print the Current Topic
• Full-Text Search
• Use Full-Text Search
• Advanced Full-Text Search
• Search for Information
• Find Information with Advanced Full-Text Search
• Search for Words or Phrases
• Define Search Terms
• Use Nested Expressions
• Search for Words in the Titles of Topic Files
• Find Words Similar to Your Search Term
• Search Previous Results
• About Microsoft Press