Northwind数据库分析:
<br />存储过程:<br />1。CustOrderHist:<br />CREATE PROCEDURE CustOrderHist @CustomerID nchar(5)<br />AS<br />SELECT ProductName, Total=SUM(Quantity)<br />FROM Products P, [Order Details] OD, Orders O, Customers C<br />WHERE C.CustomerID = @CustomerID<br />AND C
原创
2010-11-26 16:55:00 ·
1614 阅读 ·
1 评论