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