BEGIN TRAN tran_upd_courses
   update courses
   set hour=45
   where cid='10051     '
-----設(shè)置事務(wù)保存點(diǎn)
   SAVE TRAN tran_upd_courses_done
   insert into teachers
   values('1234567890','zs','my@zsu.edu.cn',3000)
   IF @@ERROR!=0 OR @@ROWCOUNT>1
      BEGIN
        -----撤消事務(wù)
      ROLLBACK TRAN tran_upd_teachers_done
      PRINT '更新教師表信息失敗!'
      RETURN
      END
   ---提交事務(wù)
COMMIT TRAN tran_upd_course