Sql Server Sql语句学习

begin transaction

  begin try 

    delete from sys_permission_menu where permission_code = #{permission_code};

    insert into sys_permission_menu(permission_code, menu_code) 

       select #{permission_code} as permission_code, menu_code from sys_menu where menu_code  in (${menu_code}); 

    select  1  success;

commit transaction 

  end try

  begin catch

    select  0  success;

rollback transaction

  end catch;

begin transaction:开始一个事物；commit transaction：提交事物，rollback transaction:异常，回滚事物

begin try 异常处理机制；