Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Table of content
Programming Microsoft SQL Server 2000 With Xml
Authors:
Malcolm G.
Published year: 2005
Pages: 1/89
Buy this book on amazon.com >>
1
2
Cover
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
1
2
Programming Microsoft SQL Server 2000 With Xml
Authors:
Malcolm G.
Published year: 2005
Pages: 1/89
Buy this book on amazon.com >>
Book categories
Computers & Technology
Programming
Languages & Tools
XML (55)
Networking
Microsoft
Development
SQL Server (40)
Hardware
Microprocessors & System Design
Databases
SQL (70)
Education & Reference