tjy_insert.sql

本人自己编写的!!!!!看看这样做的怎么样

 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