SQL Written question: Create a trigger on the borrow table to complete the following functions: If the reader borrows the title "b002", the reader's borrowing record is saved in the Borrow_save table (Note orrow_save table structure and borrow table)

CREATE TRIGGER Tr_borrow on borrow
After INSERT
As
IF ((select I.bno from INSERTED I) in (select BNO from BOOKS WHERE bname= ' b002 '))
BEGIN
INSERT Borrow_save
SELECT * from INSERTED I
PRINT ' has backed up this record '
END
ELSE
BEGIN
PRINT ' did not back up this record '
END

SQL Written question: Create a trigger on the borrow table to complete the following functions: If the reader borrows the title "b002", the reader's borrowing record is saved in the Borrow_save table (Note orrow_save table structure and borrow table)