create trigger triggerBook
on Userinfo
for Update
as
if update(username)
begin
update bookBorrowInfo set username = i.username from bookBorrowInfo b ,Deleted d,Inserted i
where b.username = d.username
end
--just update