我正在尝试添加两个变量
DECLARE @RentsSum MONEY
SET @RentsSum = (SELECT SUM(Price)
FROM Rents
WHERE StartDate IS NOT NULL)
GO
DECLARE @SalesSum MONEY
SET @PriceSum = (SELECT SUM(Price)
FROM Purchases
WHERE DateBought IS NOT NULL)
GO
DECLARE @SalesAndRentsSum MONEY
SET @SalesAndRentsSum = @RentsSum + @PriceSum;
SELECT @SalesAndRentsSum
合而为一,但我在这里遇到一些奇怪的错误...
必须声明标量变量“ @PriceSum”。
必须声明标量变量“ @RentsSum”。
删除所有GO
单词。您在此处有三个单独的批次,并且必须在该批次的范围内声明变量。
DECLARE @RentsSum MONEY, @SalesSum MONEY, @SalesAndRentsSum MONEY
SET @RentsSum = (SELECT SUM(Price)
FROM Rents
WHERE StartDate IS NOT NULL)
SET @SalesSum = (SELECT SUM(Price)
FROM Purchases
WHERE DateBought IS NOT NULL)
SET @SalesAndRentsSum = @SalesSum + @PriceSum
SELECT @SalesAndRentsSum
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句