ASP动态生成HTML页面

【文件属性】：

文件名称：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