create trigger tri_user_book
on user_book
after update
as
begin
update book_borrow set book_borrow=user_book.borrow_is
from book_borrow
inner join inserted user_book on book_borrow.book_borrow=user_book.borrow_is
end
///
create trigger book_book_borrow
on books
for insert
as
declare @book_name varchar(20)
declare @book_num varchar(20)
--declare @book_borrow_is int
-- select @a=id from inserted
select @book_name=book_name,@book_num=book_num from inserted
insert into book_borrow(book_borrow_num,book_borrow_name)values(@book_num,@book_name)