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
The .NET Developers Guide to Directory Services Programming
Introduction to .NET Directory Services Programming
Optimizing Search Performance
Summary
Discovering the Cause of Authentication Failures
Summary
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Objectives of this book
Case #1 background: RailCo Ltd.
Service layer configuration scenarios
The bottom-up strategy
Service-Oriented Design (Part III: Service Design)
An Introduction to Design Patterns in C++ with Qt 4
Getting Help Online
Review Questions
Overloading, Hiding, and Overriding
Appendix A. C++ Reserved Keywords
Appendix B. Standard Headers
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 36. Estimate Network Performance
Hack 44. Authenticate Wireless Users
Hack 73. Run Linux on the Zipit Wireless Messenger
Hack 75. Capture Wireless Users on a Small Scale
Hack 80. Redirect Brought to you by Bonjour Ads
Microsoft VBScript Professional Projects
What Is VBScript?
Errors, Constants, and Variables
Data Collection, Notification, and Error Reporting
Reporting Application Summary Data via the Web
Converting Reports to HTML Pages
.NET-A Complete Development Cycle
Project Planning
Requirements for Performance Optimization
References for Further Reading
Implementation of Online Photo Shop
Database Access with ADO.NET
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