/*
	So far, we have seen, how to rename the <root> element
	as well as the columns. Now let us see how to rename the 
	names of rows. By default the AUTO keyword generates rows
	with the name of the table/alias. 
*/

SELECT 
	OrderNumber, 
	ItemNumber, 
	Qty 
FROM OrderDetails itemInfo FOR XML AUTO, TYPE, ELEMENTS, ROOT('orderInfo')

/*
OUTPUT:

<orderInfo>
  <itemInfo>
    <OrderNumber>00001</OrderNumber>
    <ItemNumber>A001</ItemNumber>
    <Qty>10</Qty>
  </itemInfo>
  <itemInfo>
    <OrderNumber>00001</OrderNumber>
    <ItemNumber>A002</ItemNumber>
    <Qty>20</Qty>
  </itemInfo>
  <itemInfo>
    <OrderNumber>00001</OrderNumber>
    <ItemNumber>A003</ItemNumber>
    <Qty>30</Qty>
  </itemInfo>
</orderInfo>
*/