The for xml clause in select statements and the forxmlj function map SQL result sets to SQLX-XML documents, using the SQLX-XML format defined by the ANSI SQLX standard. For example:
1> select name, type from systypes 2> where name like “%var%” 3> for xml 4> go
-------------------------------
<resultset xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>
<row>
<name>nvarchar</name>
</row>
<row>
<name>univarchar</name>
</row>
<row>
<name>varbinary</name>
</row>
<row>
<name>varchar</name>
<type>39</type>
</row>
</resultset>
For more information, see XML Services in Adaptive Server Enterprise.
