Microsoft® SQL Server® 2012 Bible

358

Part III: Advanced T-SQL Data Types and Querying Techniques

<OrderNumber>10003</OrderNumber>

<OrderDate>2011-06-17T00:00:00</OrderDate>

<c>

<Name>Scott</Name>

</c>

</o>

<o>

<OrderNumber>10004</OrderNumber>

<OrderDate>2011-06-18T00:00:00</OrderDate>

<c>

<Name>Adam</Name>

</c>

</o>

*/

Although the previous query works, the problem is no one knows what c and o are. XML is

all about describing the data, so remove the alias on the customer and rename the Orders

alias to [Order].

SELECT [Order].OrderNumber, [Order].OrderDate, Customer.Name

FROM Orders [Order]

INNER JOIN Customer ON [Order].CustomerID = Customer.CustomerID

FOR XML AUTO, ELEMENTS

Now the XML is more readable.

<Order>

<OrderNumber>10001</OrderNumber>

<OrderDate>2011-06-15T00:00:00</OrderDate>

<Customer>

<Name>Scott</Name>

</Customer>

</Order>

<Order>

<OrderNumber>10002</OrderNumber>

<OrderDate>2011-06-16T00:00:00</OrderDate>

<Customer>

<Name>Adam</Name>

</Customer>

</Order>

<Order>

<OrderNumber>10003</OrderNumber>

<OrderDate>2011-06-17T00:00:00</OrderDate>

<Customer>

<Name>Scott</Name>

</Customer>

</Order>

<Order>

<OrderNumber>10004</OrderNumber>

<OrderDate>2011-06-18T00:00:00</OrderDate>

c14.indd 358c14.indd 358 7/30/2012 4:49:03 PM7/30/2012 4:49:03 PM

http://www.it-ebooks.info