Special Offers

Programming Microsoft® SQL Server™ 2000 with XML
Author Graeme Malcolm of Content Master Ltd.
Pages 304
Disk 1 Companion CD(s)
Level All Levels
Published 05/30/2001
ISBN 9780735613690
ISBN-10 0-7356-1369-9
Price(USD) $59.99
To see this book's discounted price, select a reseller below.

More Information

About the Book
Table of Contents
Sample Chapter
Related Series
Related Books
About the Author

Support: Book & CD

Rate this book
Barnes Noble Amazon Quantum Books


Table of Contents

1   SQL, XML, and the Business Internet1
    Relational Data and SQL1
    The Challenge of Integration3
    XML to the Rescue4
        Representing Business Entities with XML5
    Web-Enabling a Business Using XML9
        Using XML in Business to Consumer (B2C) Solutions9
        Using XML in Business to Enterprise (B2E) Solutions10
        Using XML in Business to Business (B2B) Solutions10
        Web-Enabling Northwind Traders with XML11
2   Retrieving XML Data Using Transact-SQL13
    The SELECT…FOR XML Statement13
    Using RAW Mode15
        Using Joins in RAW Mode Queries15
        Using Column Aliases to Specify Attribute Names16
    Using AUTO Mode16
        Using Aliases in AUTO Mode Queries17
        Joins in AUTO Mode17
        Using the ELEMENTS Option18
    Using EXPLICIT Mode19
        Identifying the Required Universal Table20
        Directives in EXPLICIT Mode Queries22
        Retrieving Subelements with the element and xml Directives22
        Using EXPLICIT Mode to Retrieve Related Data24
        Sorting Data with the hide Directive28
        Using the xmltext Directive to Retrieve XML Values29
        Retrieving CDATA with the cdata Directive31
        Using the ID, IDREF, and IDREFS Directives and the XMLDATA Option32
    Retrieving Binary Fields with the BINARY BASE64 Option33
3   Using ADO for XML Data Access35
    An ADO Refresher36
    XML Query Templates36
        Submitting a FOR XML Query37
        Calling a Stored Procedure38
    Using ADO to Execute XML Queries39
        Submitting an XML Query Using the MSSQLXML Dialect40
        Submitting an XML Query as a Stream Object42
    XML-Related SQLOLEDB Provider Properties45
        Applying a Style Sheet with the XSL Property45
        Using Relative Paths and the Base Path Property45
        Controlling File References with the SS Stream Flags Property46
        Managing the Output Format with the Output Encoding Property47
4   Using HTTP for Data Access49
    SQL Server HTTP Publishing Architecture49
    Publishing a Database Through an IIS Virtual Directory50
        Specifying a Name and a Path for the Virtual Directory51
        Securing the Virtual Directory53
        Specifying the Data Source56
        Specifying Data Access Settings57
        Creating Virtual Names58
        Specifying Advanced Options60
    Scripting Virtual Directory Configuration60
        The SQLVDirControl Object61
        The SQLVDirs Collection Object62
        The SQLVDir Object62
        The VirtualNames Collection Object63
        The VirtualName Object64
    Using URL Queries to Test a Virtual Directory64
        Retrieving XML Documents Using a URL Query64
        Encoding Special Characters in a URL Query65
        Specifying a Style Sheet in a URL Query66
        Specifying a Content Type67
        Executing Stored Procedures in a URL Query69
5   Using XML Templates to Retrieve Data over HTTP71
    What Is a Template?71
    Creating Templates72
        Creating Parameterized Templates73
    Applying Style Sheets with Templates73
        Applying a Style Sheet on the Server75
        Applying a Style Sheet on the Client Side78
    Posting a Template79
        Posting a Template from an HTML Form79
        Posting Templates from Non-HTML Clients81
6   Retrieving Data with Mapping Schemas85
    XML Schemas—An Overview85
        Defining an XML Document with a Schema86
        XML-Data Reduced (XDR) Schemas86
        An Example Schema87
    Mapping Schemas88
        Using Default Mappings89
        Using Annotations to Map Data90
    Using a Mapping Schema to Retrieve Data94
        Using an XPath Expression with a Schema94
        Using Mapping Schemas with ADO95
        Using Mapping Schemas over HTTP99
        Caching Schemas101
    Advanced Annotations102
        Defining Constants in a Schema102
        Specifying Key Fields106
        Filtering Values109
        Using ID, IDREF, and IDREFS Annotations110
        Specifying a Target Namespace113
        Retrieving Binary Data115
        Retrieving CDATA Sections116
        Retrieving Overflow Columns117
7   Inserting XML Data Using OpenXML119
    A Model for Receiving XML Documents119
        Passing XML Data to a Stored Procedure120
        Parsing and Shredding an XML Document120
        Cleaning Up121
    Generating Rowsets with the OpenXML Function122
        Specifying the Row Pattern123
        Using Flags to Retrieve Attributes and Elements126
        Defining the Rowset Schema127
    Using OpenXML to Insert Data129
        Inserting Data into an Existing Table129
        Creating a New Table132
    Using OpenXML to Retrieve XML Metadata133
        Inserting Overflow Data134
        Creating an Edge Table135
8   Additional XML Tools139
    Installing the XML For SQL Server 2000 Web Release 139
        XML For SQL Server 2000 Web Release 1 at a Glance140
    Modifying Data with Updategrams141
        Anatomy of an Updategram141
        Mapping Data in an Updategram142
        Handling NULLs in an Updategram144
        Using Parameters in an Updategram144
        Updating Multiple Rows146
        Updategram Results147
        Inserting Rows with an Updategram148
        Deleting Data with an Updategram152
        Updategrams and Concurrency153
        Combining INSERT, UPDATE, and DELETE Operations in an Updategram156
    The XML Bulk Load Component157
        How the Bulk Load Component Works157
        Bulk Loading XML Data 159
        Maintaining Referential Integrity160
        Generating the Database Schema166
9   Building an E-Commerce Solution with SQL Server and XML171
    The Sample E-Commerce Scenario171
        Overview of the E-Commerce Scenario172
        Challenges in the E-Commerce Scenario173
    The Online Retail Web Site174
        Displaying Product Categories175
        Displaying the Products in a Specified Category178
        Displaying Product Details182
        Customer Authentication185
        Managing the Shopping Basket188
        Checking Out195
    Order Processing at the Supplier200
        Inserting the Order in the Supplier Database201
        Preparing Goods for Shipment with the Order Picking Application202
        Sending the Order Details to the Delivery Company208
    Viewing Delivery Information211
    Updating the Catalog212
        Downloading the Catalog213
        Importing the Catalog Data215
    Invoicing the Retailer216
        Introducing BizTalk Server 2000216
        BizTalk Server Messaging216
APPENDIX   Introduction to XML229
    What Is XML?229
        XML Tags Up Close231
        Representing Data in an XML Document232
    Navigating XML Documents with XPath237
        Specifying a Location Path239
        Using Criteria in Location Paths241
    XSL Style Sheets241
        XSL Style Sheet Documents242
        Using Multiple Templates in a Style Sheet248
        Applying Style Sheets250
    XML Data Schemas252
        Creating an XDR Schema252
        Specifying a Content Model254
        Limiting the Content of an Element256
        Determining the Required Occurrences of Data257
        Specifying Data Types258
        Validating an XML Document260

Top of Page

Last Updated: Saturday, July 7, 2001