AUTO mode of FOR XML

AUTO mode returns query results as nested XML elements.

This does not provide much control over the shape of the XML generated from a query result.

The AUTO mode queries are useful to generate simple hierarchies.

SELECT CID, ORDERID, STATUS,
FROM CUSTOMER, ORDER
WHERE CID = ORDERID
ORDER BY CID
FOR XML AUTO 

<<Previous   Next>>