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