- 论坛徽章:
- 0
|
CREATE DEFINER=`root`@`localhost` PROCEDURE `Sf_StudentInfo`(in Sf_xh varchar(20),in Sf_fjbm varchar(20),in Sf_cwh int,out Sf_ErrNo int)
BEGIN
if exists(select * from Zsdj where xh=Sf_xh and yxbz='1') then
set Sf_ErrNo=1;
end if;
if exists(select * from Zsdj where fjh=Sf_fjbm and cwh=Sf_cwh) then
set Sf_ErrNo=2;
end if;
if exists(select * from Fjgl where fjbm=Sf_fjbm and zcws-yzrs>0) then
set Sf_ErrNo=3;
Else
set Sf_ErrNo=4;
end if;
END$$
DELIMITER ;$$
------------------------------------
call Sf_StudentInfo('048','F20050510160659', 2,1);
偶写的存储过程有错吗?为什么没有返回值呀??????谢谢 |
|