【文件属性】:
文件名称:ASP动态生成HTML页面
文件大小:54KB
文件格式:DOC
更新时间:2011-10-01 05:39:21
ASP
Northwind数据存储过程实例
1.SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE CustOrderHist @CustomerID nchar(5) AS
SELECT ProductName, Total=SUM(Quantity)
FROM Products P, [Order Details] OD, Orders O, Customers C
WHERE C.CustomerID = @CustomerID
AND C.CustomerID = O.CustomerID AND O.OrderID = OD.OrderID AND OD.ProductID = P.ProductID
GROUP BY ProductName
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO