我有这个过程,但是当它工作得很好时,没有两个if正在设置输出参数@bit。当我尝试执行proc p3时,会发生以下错误Must declare the scalar variable "@bit".
这是密码
create proc p3 @codP int, @codM int, @dela datetime, @panala datetime, @pret smallint, @bit bit output
as
begin
declare @val smallint
set @val = (select COUNT(*)
from OferteSpeciale as OS
where OS.codP = @codP and OS.codM = @codM and
((@panala >= OS.dela and @panala <= OS.panala)
or (@dela >= OS.dela and @dela <= OS.panala) or
(@dela <= OS.dela and @panala >= OS.panala)))
print @val
if (@val = 0)
begin
insert into OferteSpeciale (codP,codM,dela,panala,pret) values (@codP,@codM,@dela,@panala,@pret)
declare @others smallint
set @others = (select COUNT(*)
from Cataloage as c, OferteSpeciale as os
where ((c.codM = @codM and c.codP = @codP and c.pret < @pret) or
(os.codM = @codM and os.codP = @codP and os.pret < @pret)))
if (@others > 0)
set @bit = 0
else
set @bit = 1
end
else
RAISERROR 50001 'There is already a special offer for that product, in that shop, between that dates'
end
declare @bit bit
exec p3 1, 3, '2013-04-15', '2013-04-15', 25, @bit output
最佳答案
作为一个快速的回答,您在声明存储过程之后丢失了一个“go”,如果我尝试按您提供的方式运行它,那么如果我添加一个go以将声明从执行中分离出来,就会出现另一个错误。
end
GO
declare @bit bit
exec p3 1, 3, '2013-04-15', '2013-04-15', 25, @bit output
显然,我不得不删除存储过程的内容,因为我的数据库中没有这些对象,但问题似乎是围绕“@bit”
关于sql - 必须在存储过程中将标量变量“@bit”声明为输出参数,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/15768555/