Sybase12.5.2存储过程的返回参数值
存储过程如下,但不管是执行上一部分还是下一部分,@WCIS_Result的值总是不变。
CREATE PROCEDURE dbo.WCISP_05101
@WCIS_002 nvarchar( 50 ) ,
@WCIS_003 nvarchar( 50 ) ,
@WCIS_004 nvarchar( 50 ) ,
@WCIS_005 nvarchar( 255 ) ,
@WCIS_Result bit output
AS
BEGIN
if not exists ( select * from WCISTA_051 where WCIS_002 = @WCIS_002 and WCIS_003 = @WCIS_003 )
begin
insert into WCISTA_051( WCIS_002 , WCIS_003 , WCIS_004 , WCIS_005 ) values ( @WCIS_002 , @WCIS_003 , @WCIS_004 , @WCIS_005 )
select @WCIS_Result = 1
end
else
begin
select @WCIS_Result = 0
end
END