orderspathsample1.sql

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

SELECT TOP 10 OrderID AS [@OrderID], CustomerID AS [@CustomerID], EmployeeID AS [@EmployeeID], OrderDate, ShippedDate,
(SELECT Quantity AS [LineItem/Quantity], Products.ProductID AS [LineItem/SKU],
ProductName AS [LineItem/Product], QuantityPerUnit AS [LineItem/Package],
[Order Details].UnitPrice AS [LineItem/ListPrice],
Discount AS [LineItem/Discount]
FROM [Order Details], Products
WHERE [Order Details].OrderID = Orders.OrderID AND Products.ProductID = [Order Details].ProductID
FOR XML PATH(''), TYPE) AS LineItems
FROM Orders
WHERE OrderID < 11077
ORDER BY OrderID DESC
FOR XML PATH('Order'), ELEMENTS XSINIL, TYPE, ROOT('Orders')