摘要:
CREATE PROCEDURE p1(idd int)BEGINDECLARE EXIT HANDLER FOR SQLEXCEPTION,SQLWARNING,NOT FOUND BEGINROLLBACK; END;SET @comId = idd ;START TRANSACTION;DELETE FROM tb_aa WHERE id=@comId;DELETE FROM tb_bb WHERE id=@comId;COMMIT; END 阅读全文
posted @ 2012-06-25 16:31 HI END 阅读(373) 评论(0) 推荐(0)
浙公网安备 33010602011771号