SQL笔试题：在BORROW表上建立一个触发器，完成如下功能：如果读者借阅的书名是"b002"，就将该读者的借阅记录保存在BORROW_SAVE表中（注ORROW_SAVE表结构同BORROW表）...

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 '已经备份该记录'
END
ELSE
BEGIN
PRINT '未备份该记录'
END

转载于:https://www.cnblogs.com/hongyan5682/p/4353886.html