tjy_delete.sql

有读者和图书信息的添加查询,借还书等,先建立数据库和ODBC数据源

create trigger tjy_delete on zzyjy
for delete 
as
  begin
       update zzyxs
              set 借书量=借书量-1
               where zzyxs.借书证号 in
               (select deleted.借书证号
                from deleted)
       update zzybook
              set 库存量=库存量+1
                   where zzybook.ISBN in
                       (select deleted.ISBN
                           from deleted)
  end