触发在更新后和更新前插入新值和旧值 [英] Trigger to insert New Value And Old Value after update and before update

问题描述

亲爱的所有人，



请我想创建触发器，将旧值和新值插入另一个表中



以及如何从我的C＃应用​​程序中传递值



可为此pleaseeeee提供任何帮助





谢谢

解决方案

触发后尝试使用

 创建  TRIGGER  ShowUpdate   YourTable 
 AFTER 更新 
  AS  
  BEGIN  
  INSERT   INTO  NewDataTable 
  SELECT  id，name  FROM  inserted 
 
  INSERT   INTO  OldDataTab le 
  SELECT  id，name  FROM 已删除
  END  

Dear All,

please i want to create trigger that will insert into another table the old value and new value

and how can i pass values from my C# application

can any one help for this pleaseeeee


thanks

解决方案

Try this use after trigger

CREATE TRIGGER ShowUpdate on YourTable
AFTER  UPDATE
AS
BEGIN
INSERT INTO NewDataTable
   SELECT id, name  FROM inserted

INSERT INTO OldDataTable
   SELECT id, name  FROM Deleted 
END

这篇关于触发在更新后和更新前插入新值和旧值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！