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
Qshell for iSeries
Parameters and Variables, Defined
Writing Programs for Qshell
The Perl Utility
Java Development Tools
Appendix A Summary of Changes by Release
Documenting Software Architectures: Views and Beyond
Styles of the Module Viewtype
Shared-Data Style
Stakeholders of Interface Documentation
One Document or Several?
C&C Pipe-and-Filter View
FileMaker Pro 8: The Missing Manual
Checking Spelling
Relational Databases
Working with Windows
Organizing Complex Scripts
Handling Errors
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
Computers as Persuasive Tools
Computers as Persuasive Social Actors
Credibility and the World Wide Web
Increasing Persuasion through Mobility and Connectivity
Captology Looking Forward
AutoCAD 2005 and AutoCAD LT 2005. No Experience Required
Gaining Drawing Strategies: Part 1
Gaining Drawing Strategies: Part 2
Generating Elevations
Dimensioning a Drawing
Managing External References
Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
Data Source Events
Conclusion
Conclusion
Binding-Related Extensions to Host Items and Host Controls
Deploying Policy to User Machines
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