一个简单的存储过程:
create PROCEDURE e_gjjbackcredit @errnumber int OUTPUT
AS
begin
select @errnumber=-1
return -1
end
在查询分析器里执行这个存储过程:declare @errnumber int
declare @return intexecute @return = e_gjjbackcredit @errnumber = @errnumberselect @return,@errnumber但结果却是:
-1 null为什么返回的@errnumber的值为null啊?
create PROCEDURE e_gjjbackcredit @errnumber int OUTPUT
AS
begin
select @errnumber=-1
return -1
end
在查询分析器里执行这个存储过程:declare @errnumber int
declare @return intexecute @return = e_gjjbackcredit @errnumber = @errnumberselect @return,@errnumber但结果却是:
-1 null为什么返回的@errnumber的值为null啊?
declare @return int execute @return = e_gjjbackcredit @errnumber = @errnumber outputselect @return,@errnumber