/*
	Though the query returns the results in XML format, 
	it is not an XML data type. The result is NVARCHAR.
	To return the results as an XML data type, use the
	keyword TYPE. 
*/

SELECT OrderNumber, ItemNumber, Qty FROM OrderDetails FOR XML AUTO, TYPE

/*
OUTPUT:

<OrderDetails OrderNumber="00001" ItemNumber="A001" Qty="10" />
<OrderDetails OrderNumber="00001" ItemNumber="A002" Qty="20" />
<OrderDetails OrderNumber="00001" ItemNumber="A003" Qty="30" />
*/