Examples of publishing XML values

The following examples show how you can construct XML values with SQL/XML publishing functions and with XQuery expressions.

Example: Construct an XML document with constant values
This simple example shows how you can construct constant XML values suitable for publishing with SQL/XML publishing functions.
Example: Construct an XML document with values from a single table
This example shows how you can construct XML values suitable for publishing from a single table with SQL/XML publishing functions.
Example: Construct an XML document with values from multiple tables
This example shows how you can construct XML values suitable for publishing from multiple tables with SQL/XML publishing functions.
Example: Construct an XML document with values from table rows that contain null elements
This example shows how you can construct XML values suitable for publishing from table rows that contain null elements with SQL/XML publishing functions.
Example: Publishing data with XQuery
This example shows how you can construct XML values suitable for publishing not only with SQL/XML publishing functions but also with XQuery expressions.

Parent topic: SQL/XML publishing functions for constructing XML values