sql:encode

When an XML element or attribute is mapped to a SQL Server BLOB column, allows requesting a reference URI. This URI can be used later to return BLOB data.

Requesting URL References to BLOB Data Using sql:encode (SQLXML 4.0)

url-encode

sql:field

Maps an XML item to a database column.

Using sql:field (XDR Schema)

Same

sql:guid

Allows you to specify whether to use a GUID value generated by SQL Server or use the value provided in the updategram for that column.

Using the sql:identity and sql:guid Annotations

Not supported

sql:hide

Hides the element or attribute that is specified in the schema in the resulting XML document.

Hiding Elements and Attributes by Using sql:hide

Not supported

sql:identity

Can be specified on any node that maps to an IDENTITY-type database column. The value specified for this annotation defines how the corresponding IDENTITY-type column in the database is updated.

Using the sql:identity and sql:guid Annotations

Not supported

sql:inverse

Instructs the updategram logic to inverse its interpretation of the parent-child relationship that has been specified using <sql:relationship>.

Specifying the sql:inverse Attribute on sql:relationship (SQLXML 4.0)

Not supported

sql:is-constant

Creates an XML element that does not map to any table. The element appears in the query output.

Creating Constant Elements Using sql:is-constant (SQLXML 4.0)

Same

sql:key-fields

Allows specification of column(s) that uniquely identify the rows in a table.

Identifying Key Columns Using sql:key-fields (SQLXML 4.0)

Same

sql:limit-field

sql:limit-value

Allows limiting the values that are returned on the basis of a limiting value.

Filtering Values Using sql:limit-field and sql:limit-value (SQLXML 4.0)

Same

sql:mapped

Allows schema items to be excluded from the result.

Excluding Schema Elements from the Resulting XML Document Using sql:mapped (SQLXML 4.0)

map-field

sql:max-depth

Allows you to specify depth in recursive relationships that are specified in the schema.

Specifying Depth in Recursive Relationships by Using sql:max-depth

Not supported

sql:overflow-field

Identifies the database column that contains the overflow data.

Retrieving Unconsumed Data Using the sql:overflow-field (SQLXML 4.0)

Same

sql:prefix

Creates valid XML ID, IDREF, and IDREFS. Prepends the values of ID, IDREF, and IDREFS with a string.

Creating Valid ID, IDREF, and IDREFS Type Attributes Using sql:id-prefix (XDR Schema); Creating Valid ID, IDREF, and IDREFS Type Attributes Using sql:prefix (SQLXML 4.0)

Same

sql:relation

Maps an XML item to a database table.

Using sql:relation (XDR Schema)

Same

sql:relationship

Specifies relationships between XML elements. The parent, child, parent-key, and child-key attributes are used to establish the relationship.

Specifying Relationships Using sql:relationship (SQLXML 4.0)

The attribute names are different:

key-relation

foreign-relation

key

foreign-key

sql:use-cdata

Allows specifying CDATA sections to be used for certain elements in the XML document.

Creating CDATA Sections Using sql:use-cdata (SQLXML 4.0)

Same