Query Results as XML rather than standard rowsets - SQL
Note-This Clause is valid only in the SELECT and not valid in COMPUTE BY or FOR BROWSE, view definition , cursors and for further processing in a stored procedure
some times we need the result of the query in xml format. so that we can use the output directly in the code.
USE pubs
SELECT type,
price,
advance
FROM titles
FOR XML AUTO