古詩詞大全網 - 個性簽名 - sql存儲過程返回值能為表格嗎

sql存儲過程返回值能為表格嗎

sqlserver可以的。

CREATE PROCEDURE OrderSummary @MaxQuantity INT OUTPUT AS

SELECT Ord.EmployeeID, SummSales = SUM(OrDet.UnitPrice * OrDet.Quantity)

FROM Orders AS Ord

JOIN [Order Details] AS OrDet ON (Ord.OrderID = OrDet.OrderID)

GROUP BY Ord.EmployeeID

ORDER BY Ord.EmployeeID

SELECT @MaxQuantity = MAX(Quantity) FROM [Order Details]

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

GO