如何DECLARE @T從存盤程序中獲取此值？
這是我的存盤程序：
ALTER PROCEDURE [dbo].[sp_GetTotlePrice]
(@Users_Id bigint)
AS
BEGIN
DECLARE @R TABLE
(
Price bigint,
Quantity bigint
)
INSERT INTO @R
SELECT TOP 1000000
M.Price, B.Quantity
FROM
Basket B
INNER JOIN
Medicaments M ON M.Medicament_Id = B.Medicament_Id
WHERE
@Users_Id = B.Users_Id
SELECT SUM(Price * Quantity) FROM @R
END
uj5u.com熱心網友回復：
我首先發現了我的錯誤，我需要在我添加的存盤程序中回傳一個值
DECLARE @T AS bigint
SELECT @T = SUM(Price * Quantity) From @R AS TotlePrice
--SELECT SUM(Price * Quantity) From @R AS TotlePrice
RETURN @T
然后
DECLARE @return_value bigint
EXEC @return_value = [dbo].[sp_GetTotlePrice]
10
SELECT 'Return Value' = @return_value
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/523330.html
標籤：sql数据库存储过程