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
Agile Project Management: Creating Innovative Products (2nd Edition)
Phase: Adapt
Practice: Product Architecture
Practice: Process and Practice Tailoring
Practice: Daily Team Integration Meetings
Self-Organization Extensions
Lotus Notes and Domino 6 Development (2nd Edition)
Types of Applications
Adding Framesets to Domino Applications
Creating Web Agents Using Formulas and LotusScript
Working with Documents
What Its All About: XML Exposed
The Complete Cisco VPN Configuration Guide
Network Access Control (NAC) for IPsec and L2TP/IPsec Users
Summary
Overview of the 3002 Hardware Client
IPsec Preparation
Easy VPN Server Support for 7.0
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
Computers as Persuasive Tools
Computers as Persuasive Media Simulation
Computers as Persuasive Social Actors
Credibility and Computers
Captology Looking Forward
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Cause and Effect
Blue-Screen Garbage Mattes
Static Matte Painting in Photoshop
Making Movies from Stills
Motion Titling Effects
InDesign Type: Professional Typography with Adobe InDesign CS2
An InDesign Type Map: Where to Find Stuff
Sweating the Small Stuff: Special Characters, White Space, and Glyphs
Glyph Positioning
Up Next
Changing Columns
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