tjy_delete.sql

来自「本人自己编写的!!!!!看看这样做的怎么样」· SQL 代码 · 共 12 行

create trigger tjy_delete on jy
     for delete as 
     begin 
         update xs
              set 借书数=借书数-1
                 where xs.借书证号 in
                   (select deleted.借书证号 from deleted)
              update book
                   set 库存量=库存量+1
                       where book.isbn in
                            (select deleted.isbn from deleted)
end