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

posted @ 2015-03-20 16:02  hongyan5682  阅读(621)  评论(0编辑  收藏  举报