例子:
if exists(select * from reporinfo where
reporttitle=@reporttitle)
begin
set @issucess=1
end
else
begin
set @issucess=2
end
程序调用上述存储过程时,总是返回0
修改如下:
if exists(select * from reporinfo where
reporttitle=@reporttitle)
begin
set @issucess=1
return @issucess
end
else
begin
set @issucess=2
return @issucess
end
则会返回对应的值