4.1.6.sql

清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码

BEGIN TRAN tran_upd_courses
   update courses
   set hour=60
   where cid='10051     '
   BEGIN TRAN tran_upd_teachers
       insert into teachers
       values('1234567890','zs','[e-mail]',3000)
   IF @@ERROR!=0 
      BEGIN
       -------撤消事务
      ROLLBACK TRAN tran_upd_teacher
      PRINT '更新教师表失败'
      RETURN
      END
   --提交内层事务
   COMMIT TRAN tran_upd_teachers
   ----提交外层事务
   COMMIT TRAN tran_upd_courses