/*
	So far, we have seen how to assign a custom name to the <root> element as 
	well as a custom name to each row. it is also possible to give a custom
	name to each element by using a column alias. The following example shows that.  
*/

SELECT 
	OrderNumber as 'OrderNum', 
	ItemNumber as ItemCode, 
	Qty as Quantity 
FROM OrderDetails FOR XML AUTO, TYPE, ELEMENTS, ROOT('itemInfo')

/*
OUTPUT:

<itemInfo>
  <OrderDetails>
    <OrderNum>00001</OrderNum>
    <ItemCode>A001</ItemCode>
    <Quantity>10</Quantity>
  </OrderDetails>
  <OrderDetails>
    <OrderNum>00001</OrderNum>
    <ItemCode>A002</ItemCode>
    <Quantity>20</Quantity>
  </OrderDetails>
  <OrderDetails>
    <OrderNum>00001</OrderNum>
    <ItemCode>A003</ItemCode>
    <Quantity>30</Quantity>
  </OrderDetails>
</itemInfo>
*/