Programming Microsoft SQL Server(TM) 2000 with XML (Pro-Developer)
Programming Microsoft SQL Server(TM) 2000 with XML (Pro-Developer)
ISBN: 0735613699
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 89
Pages: 89
Authors: Graeme Malcolm
- 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
Programming Microsoft SQL Server(TM) 2000 with XML (Pro-Developer)
ISBN: 0735613699
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 89
Pages: 89
Authors: Graeme Malcolm