nestedquerytyperaw.sql

来自「wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重」· SQL 代码 · 共 17 行

USE Northwind
GO
SELECT TOP 10 OrderID, CustomerID, EmployeeID, OrderDate, ShippedDate,
(SELECT ProductID, CONVERT(decimal(6,2), UnitPrice) AS UnitPrice, Quantity,
CONVERT (decimal(3,3), Discount) AS Discount
FROM [Order Details]
WHERE [Order Details].OrderID = Orders.OrderID
FOR XML RAW('OrderDetail'), ELEMENTS, TYPE, ROOT('OrderDetails'))
-- Adding XMLSCHEMA('urn:schemas-northwind-order') generates a schema for every OrderDetails group
FROM Orders
WHERE OrderID < 11072
ORDER BY OrderID DESC
FOR XML RAW('Order'), ELEMENTS XSINIL, TYPE, ROOT('Orders')
 --Uncomment below to return an inline Order element (only) schema
 --, XMLSCHEMA('urn:schemas-northwind-order')
GO