XML and Internet Support Overview
 IIS Virtual Directory Management for SQL Server
   
 System Requirements for IIS Virtual Directory Management
   
 Using IIS Virtual Directory Management for SQL Server Utility
      
 Creating the nwind Virtual Directory
   
 IIS Virtual Directory Management for SQL Server Object Model
      
 SQLVDirControl Object
      
 SQLVDirs Collection Object
      
 SQLVDir Object
      
 VirtualNames Collection Object
      
 VirtualName Object
   
 Creating the nwind Virtual Directory Using the Object Model
 Accessing SQL Server Using HTTP
   
 Three-Tier System Architecture
   
 Special Characters
   
 Executing SQL Statements Using HTTP
      
 Executing Stored Procedures Using HTTP
   
 Executing Template Files Using HTTP
      
 Using XML Templates
      
 Executing SQL Queries Using Templates
      
 Passing Parameters to Templates
      
 Specifying an XSL Style Sheet in a Template
      
 Executing XPath Queries Using Templates
   
 Executing XPath Queries Using HTTP
   
 Accessing Database Objects Using HTTP
   
 Sample Applications to Post Templates
      
 Using HTML Forms to Post Templates
      
 Posting Templates Directly to the Virtual Directory
 Creating XML Views Using Annotated XDR Schemas
   
 Annotations to the XDR Schema
      
 Default Mapping of XDR Elements and Attributes to Tables and Columns
      
 Explicit Mapping of XDR Elements and Attributes to Tables and Columns
         
 Using sql:relation
         
 Using sql:field
      
 Specifying Relationships Using <sql:relationship>
      
 Creating Constant Elements Using sql:is-constant
      
 Excluding Schema Elements from the Resulting XML Document Using sql:map-field
      
 Filtering Values Using sql:limit-field and sql:limit-value
      
 Identifying Key Columns Using sql:key-fields
      
 Specifying a Target Namespace Using sql:target-namespace
      
 Creating Valid ID, IDREF, and IDREFS Type Attributes Using sql:id-prefix
         
 Using sql:id-prefix
      
 Data Type Coercions
      
 Creating CDATA Sections Using sql:use-cdata
      
 Requesting URL References to BLOB Data Using sql:url-encode
      
 Retrieving Unconsumed Data Using sql:overflow-field
      
 Specifying Default Values for Attributes in the XDR Schema
   
 Using Annotated XDR Schemas in Queries
   
 Schema Caching
 Using XPath Queries
   
 Guidelines for Using XPath Queries
   
 Specifying a Location Path
      
 Specifying an Axis
      
 Specifying a Node Test in the Location Path
      
 Specifying Selection Predicates in the Location Path
   
 Sample XPath Queries
      
 Specifying Axes in XPath Queries
      
 Specifying Boolean-Valued Predicates in XPath Queries
      
 Specifying Relational Operators in XPath Queries
      
 Specifying Arithmetic Operators in XPath Queries
      
 Specifying Explicit Conversion Functions in XPath Queries
      
 Specifying Boolean Operators in XPath Queries
      
 Specifying Boolean Functions in XPath Queries
      
 Specifying XPath Variables in XPath Queries
   
 XPath Data Types
 Retrieving and Writing XML Data
   
 Retrieving XML Documents Using FOR XML
      
 Basic Syntax of the FOR XML Clause
      
 Guidelines for Using the FOR XML Clause
      
 Using RAW Mode
      
 Using AUTO Mode
      
 Using EXPLICIT Mode
      
 Specifying the XMLDATA Schema Option in a Query
   
 Writing XML Using OPENXML
      
 Using OPENXML
      
 Specifying Metaproperties in OPENXML
      
 XML System Stored Procedures
      
 Sample XML Applications
         
 Sample HTML Form to Insert Records Using OPENXML
         
 Sample HTML Form to Update Records Using OPENXML
         
 Sample Visual Basic Application to Update Records Using OPENXML and ADO
 OLE DB Provider for SQL Server Extensions for XML
   
 Using ICommandStream to Set an XML Command