SQL教学课程-触发器.pptVIP

第七章　;回顾 2-1;回顾 2-2;本章目标;;;;;触发器的类型;;;;INSERT触发器;;;;transInfo;;;;Deleted（更新前的数据）;;-------关键代码------ CREATE TRIGGER trig_update_bank ON bank FOR UPDATE AS DECLARE @beforeMoney MONEY,@afterMoney MONEY SELECT @beforeMoney=currentMoney FROM deleted SELECT @afterMoney=currentMoney FROM inserted IF ABS(@afterMoney-@beforeMoney)20000 BEGIN print 交易金额:+convert(varchar(8), ABS(@afterMoney-@beforeMoney)) RAISERROR (每笔交易不能超过2万元，交易失败,16,1) ROLLBACK TRANSACTION END GO ;;;-------关键代码------ CREATE TRIG