Working with Relational Data as XML

As shown in the example in the preceding section, an SQL/XML query is returned as XML. The XML is displayed in the Preview window in the DB-to-XML data source editor, as shown in Figure 389.

Figure 389. SQL/XML Query Returned as XML

You can work with an SQL/XML query result as XML and, optionally, update the relational database using changes to the XML file and the SQL/XML statements defined on the UPDATE tab of the DB-to-XML data source editor.

 
Free Stylus Studio XML Training: