tjy_insert.sql

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

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