sql补充触发器临时表与游标.pptVIP

SQL补充:　;回顾1;回顾 2;回顾 3;本章目标;;;;;触发器的类型;;;;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 T