Flylib.com
Programming Microsoft SQL Server(TM) 2000 with XML (Pro-Developer)
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
Programming Microsoft SQL Server(TM) 2000 with XML (Pro-Developer)
ISBN: 0735613699
EAN: 2147483647
Year: 2005
Pages: 89
Authors:
Graeme Malcolm
BUY ON AMAZON
A+ Fast Pass
Domain 1 Installation, Configuration, and Upgrading
Domain 2 Diagnosing and Troubleshooting
Domain 6 Basic Networking
Domain 1 Operating System Fundamentals
Domain 4 Networks
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Internet Protocol (IP) Basics
Internet Protocol (IP) Addressing
Internet Protocol (IP) Routing
Internet Control Message Protocol (ICMP)
Dynamic Host Configuration Protocol (DHCP) Server Service
GO! with Microsoft Office 2003 Brief (2nd Edition)
Chapter One. Getting Started with Outlook 2003
Objective 6. Chart Data
Objective 8. Make Comparisons Using a Pie Chart
Objective 1. Sort Records
Objective 5. Apply Bullets and Numbering
Java Concurrency in Practice
Threads are Everywhere
Delegating Thread Safety
Sizing Thread Pools
Performance Considerations
What is a Memory Model, and Why would I Want One?
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Working Within the Visio Environment
Adding Shapes to Diagrams
Storing and Displaying Employee Information in Organization Charts
Adding Door, Window, and Furniture Shapes to Office Layouts
Key Points
Digital Character Animation 3 (No. 3)
Hierarchies and Character Animation
Facial Rigging
Conclusion
Conclusion
Conclusion
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies