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里

posted @ 2015-12-31 17:08  Emerald_Sword  阅读(1575)  评论(0)    收藏  举报