[SQL]insert、update 触发器应用的demo

--创建触发器<更新表>
create  trigger stu_trg
on student 
for update
as
    declare @a varchar(100)
           ,@b varchar(100)
           
           select @a=libraryCardNo ,@b=stu_id from inserted
           update borrowbook set libraryCardNo=@a where b_id=@b


GO
--创建触发器<插入表>
create trigger insert_trg
on student
for insert
as 
    declare @a varchar(100)           
           ,@b varchar(100)
           select @a=libraryCardNo ,@b=stu_id from inserted
           insert into borrowbook(b_id,libraryCardNo)values(@b,@a)
          

GO