create procedure test_pro( IN in_sno char (6) ,
IN in_sname char (10) )
BEGIN
DECLARE v_result char (10) DEFAULT NULL;
SELECT sname INTO v_result FROM student WHERE sno=in_sno;
IF (V_RESULT IS NOT NULL) THEN
UPDATE student SET sname=in_sname WHERE sno=in_sno;
ELSE
INSERT INTO student VALUES(in_sno,in_sname);
END IF;
END
call test_pro( '990101','原野2');
DB2存储过程
最新推荐文章于 2024-08-03 19:27:22 发布