orderspathsample2.sql

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

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