XML and Internet Support
Table of contents
- XML and Internet Support Overview
- IIS Virtual Directory Management for SQL Server
- Accessing SQL Server Using HTTP
-
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
- 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
- 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
-
Annotations to the XDR Schema
-
Using XPath Queries
- Guidelines for Using XPath Queries
- Specifying a 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
- OLE DB Provider for SQL Server Extensions for XML