FOR XML嵌套示例

运用NORTHWIND\NORTHWND.MDF

declare @xml xml
set @xml=(select *,
(select * from dbo.OrderDetails
 where dbo.OrderDetails.OrderID=dbo.Orders.OrderID
 for xml raw('OrderDetails'),root('detail'),type)
 from dbo.Orders
 for xml raw('Orders'),root('root'),type)
 select @xml

部分结果如下图：