tjy_insert.sql

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

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