sqlserver可以的创建过程order summary @ max quantity INT OUTPUT AS

SELECT Ord . EmployeeID，SummSales = SUM(OrDet。单价*订单。数量)

从订单作为Ord

加入[订单详细信息]作为OrDet ON (Ord.OrderID = OrDet。OrderID)

GROUP BY Ord。EmployeeID

ORDER BY Ord。EmployeeID

SELECT @ MAX Quantity = MAX(Quantity)FROM[ORDER Details]

RETURN(SELECT SUM(Quantity)FROM[ORDER Details])

GO