摘要:
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 阅读(369) 评论(0) 推荐(0) 编辑