无参数的存储过程

? 1 2 3 4 5 6 7 CREATE PROCEDURE P_XSRBB() BEGIN         DECLARE VP1 VARCHAR(20);         SET VP1=4; SELECT VP1 FROM DUAL; END; CALL P_XSRBB();

带输入参数的存储过程

? 1 2 3 4 5 6 7 8 DROP PROCEDURE IF EXISTS P_XSRBB; CREATE PROCEDURE P_XSRBB(in vp2 INT) BEGIN         DECLARE VP1 VARCHAR(20);         SET VP1=4; SELECT VP2 FROM DUAL; END; CALL P_XSRBB(3434);