Programming Microsoft SQL Server 2000 with XML,9780735613690

Programming Microsoft SQL Server 2000 with XML

by
ISBN13: 9780735613690
ISBN10: 0735613699
Format: Trade Paper
Pub. Date: 2001-06-30
Publisher(s): Microsoft Pr
List Price: $64.19

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $25.22

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Extensible Markup Language (XML) is the lingua franca of business information exchange. And with "Programming Microsoft SQL Server 2000 With XML, " developers get the expert guidance they need to build powerful, XML-enabled database applications for lines of business, e-commerce, and the Web. All the book's code appears on the CD-ROM so readers can study and reuse them for their own projects.

Author Biography

Graeme Malcolm is a Principal Technologist for Content Master Ltd.

Table of Contents

Acknowledgments xi
Introduction xiii
SQL, XML, and the Business Internet
1(12)
Relational Data and SQL
1(2)
The Challenge of Integration
3(1)
XML to the Rescue
4(5)
Representing Business Entities with XML
5(4)
Web-Enabling a Business Using XML
9(4)
Using XML in Business to Consumer (B2C) Solutions
9(1)
Using XML in Business to Enterprise (B2E) Solutions
10(1)
Using XML in Business to Business (B2B) Solutions
10(1)
Web-Enabling Northwind Traders with XML
11(2)
Retrieving XML Data Using Transact-SQL
13(22)
The Select...for XML Statement
13(2)
Using RAW Mode
15(1)
Using Joins in RAW Mode Queries
15(1)
Using Column Aliases to Specify Attribute Names
16(1)
Using Auto Mode
16(3)
Using Aliases in Auto Mode Queries
17(1)
Joins in Auto Mode
17(1)
Using the Elements Option
18(1)
Using Explicit Mode
19(14)
Identifying the Required Universal Table
20(2)
Directives in Explicit Mode Queries
22(1)
Retrieving Subelements with the element and xml Directives
22(2)
Using Explicit Mode to Retrieve Related Data
24(4)
Sorting Data with the hide Directive
28(1)
Using the xmltext Directive to Retrieve XML Values
29(2)
Retrieving CDATA with the cdata Directive
31(1)
Using the ID, IDREF, and IDREFS Directives and the XMLDATA Option
32(1)
Retrieving Binary Fields with the Binary Base64 Option
33(1)
Summary
34(1)
Using ADO for XML Data Access
35(14)
An ADO Refresher
36(1)
XML Query Templates
36(3)
Submitting a For XML Query
37(1)
Calling a Stored Procedure
38(1)
Using ADO to Execute XML Queries
39(6)
Submitting an XML Query Using the MSSQLXML Dialect
40(2)
Submitting an XML Query as a Stream Object
42(3)
XML-Related SQLOLEDB Provider Properties
45(2)
Applying a Style Sheet with the XSL Property
45(1)
Using Relative Paths and the Base Path Property
45(1)
Controlling File References with the SS Stream Flags Property
46(1)
Managing the Output Format with the Output Encoding Property
47(1)
Summary
47(2)
Using HTTP for Data Access
49(22)
SQL Server HTTP Publishing Architecture
49(1)
Publishing a Database Through an IIS Virtual Directory
50(10)
Specifying a Name and a Path for the Virtual Directory
51(2)
Securing the Virtual Directory
53(3)
Specifying the Data Source
56(1)
Specifying Data Access Settings
57(1)
Creating Virtual Names
58(2)
Specifying Advanced Options
60(1)
Scripting Virtual Directory Configuration
60(4)
The SQLVDirControl Object
61(1)
The SQLVDirs Collection Object
62(1)
The SQLVDir Object
62(1)
The VirtualNames Collection Object
63(1)
The VirtualName Object
64(1)
Using URL Queries to Test a Virtual Directory
64(5)
Retrieving XML Documents Using a URL Query
64(1)
Encoding Special Characters in a URL Query
65(1)
Specifying a Style Sheet in a URL Query
66(1)
Specifying a Content Type
67(2)
Executing Stored Procedures in a URL Query
69(1)
Summary
69(2)
Using XML Templates to Retrieve Data over HTTP
71(14)
What Is a Template?
71(1)
Creating Templates
72(1)
Creating Parameterized Templates
73(1)
Applying Style Sheets with Templates
73(6)
Applying a Style Sheet on the Server
75(3)
Applying a Style Sheet on the Client Side
78(1)
Posting a Template
79(4)
Posting a Template from an HTML Form
79(2)
Posting Templates from Non-HTML Clients
81(2)
Summary
83(2)
Retrieving Data with Mapping Schemas
85(34)
XML Schemas---An Overview
85(3)
Defining an XML Document with a Schema
86(1)
XML-Data Reduced (XDR) Schemas
86(1)
An Example Schema
87(1)
Mapping Schemas
88(6)
Using Default Mappings
89(1)
Using Annotations to Map Data
90(4)
Using a Mapping Schema to Retrieve Data
94(8)
Using an XPath Expression with a Schema
94(1)
Using Mapping Schemas with ADO
95(4)
Using Mapping Schemas over HTTP
99(2)
Caching Schemas
101(1)
Advanced Annotations
102(16)
Defining Constants in a Schema
102(4)
Specifying Key Fields
106(3)
Filtering Values
109(1)
Using ID, IDREF, and IDREFS Annotations
110(3)
Specifyign a Target Namespace
113(2)
Retrieving Binary Data
115(1)
Retrieving CDATA Sections
116(1)
Retrieving Overflow Columns
117(1)
Summary
118(1)
Inserting XML Data Using OpenXML
119(20)
A Model for Receiving XML Documents
119(3)
Passing XML Data to a Stored Procedure
120(1)
Parsig and Shredding an XML Document
120(1)
Cleaning Up
121(1)
Generating Rowsets with the OpenXML Function
122(7)
Specifying the Row Pattern
123(3)
Using Flags to Retrieve Attributes and Elements
126(1)
Defining the Rowset Schema
127(2)
Using OpenXML to Insert Data
129(4)
Inserting Data into an Existing Table
129(3)
Creating a New Table
132(1)
Using OpenXML to Retrieve XML Metadata
133(3)
Inserting Overflow Data
134(1)
Creating an Edge Table
135(1)
Summary
136(3)
Additional XML Tools
139(32)
Installing the XML For SQL Server 2000 Web Release
139(2)
XML For SQL Server 2000 Web Release 1 at a Glance
140(1)
Modifying Data with Updategrams
141(16)
Anatomy of an Updategram
141(1)
Mapping Data in an Updategram
142(2)
Handling NULLs in an Updategram
144(1)
Using Parameters in an Updategram
144(2)
Updating Multiple Rows
146(1)
Updategram Results
147(1)
Inserting Rows with an Updategram
148(4)
Deleting Data with an Updategram
152(1)
Updategrams and Concurrency
153(3)
Combining Insert, Update, and Delete Operations in an Updategram
156(1)
The XML Bulk Load Component
157(13)
How the Bulk Load Component Works
157(2)
Bulk Loading XML Data
159(1)
Maintaining Referential Integrity
160(6)
Generating the Database Schema
166(4)
Summary
170(1)
Buildign an E-Commerce Solution with SQL Server and XML
171(58)
The Sample E-Commerce Scenario
171(3)
Overview of the E-Commerce Scenario
172(1)
Challenges in the E-Commerce Scenario
173(1)
The Online Retail Web Site
174(26)
Displaying Product Categories
175(3)
Displaying the Products in a Specified Category
178(4)
Displaying Product Details
182(3)
Customer Authentication
185(3)
Managing the Shopping Basket
188(7)
Checking Out
195(5)
Order Processing at the Supplier
200(11)
Inserting the Order in the Supplier Database
201(1)
Preparing Goods for Shipment with the Order Picking Application
202(6)
Sending the Order Details to the Delivery Company
208(3)
Viewing Delivery Information
211(1)
Updating the Catalog
212(4)
Downloading the Catalog
213(2)
Importing the Catalog Data
215(1)
Invoicing the Retailer
216(11)
Introducing BizTalk Server 2000
216(1)
BizTalk Server Messaging
216(11)
Summary
227(2)
Appendix Introduction to XML 229(34)
What Is XML?
229(8)
XML Tags Up Close
231(1)
Representing Data in an XML Document
232(3)
Namespaces
235(2)
Navigating XML Documents with XPath
237(4)
Specifying a Location Path
239(2)
Using Criteria in Location Paths
241(1)
XSL Style Sheets
241(11)
XSL Style Sheet Documents
242(6)
Using Multiple Templates in a Style Sheet
248(2)
Applying Style Sheets
250(2)
XML Data Schemas
252(9)
Creating an XDR Schema
252(2)
Specifying a Content Model
254(2)
Limiting the Content of an Element
256(1)
Determining the Required Occurrences of Data
257(1)
Specifying Data Types
258(2)
Validating an XML Document
260(1)
Summary
261(2)
Index 263

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.