SQL更新某字段时触发器
alter TRIGGER [dbo].[tri_insert_member] on [dbo].[member] for update AS begin declare @username nvarchar(50),@endMoney money,@beforeMoney money; select @username=username from inserted; select @endMoney=removeMoney from inserted; select @beforeMoney=removeMoney from deleted; if update(removeMoney) begin insert into Sys_ChangeLog values(@username,@endMoney-@beforeMoney,getdate()) end end
字段更新前的值在deleted里
更新后的值在 inserted里

浙公网安备 33010602011771号