取消档案表上的触发器
1 CREATE TRIGGER tri_ChgXJzt ON dbo.xsjb***
2 FOR UPDATE
3 AS insert into UmlChgXj
4 (xhjm,xm,xjztdm,sfzh,updatetime,sysuser,hostname,opuser,chgMark)
5 select xhjm,xm,xjztdm,sfzh,current_timestamp,System_USER,HOST_NAME(),
6 user_name(),'Before'from deleted
7 insert into UmlChgXj
8 (xhjm,xm,xjztdm,sfzh,updatetime,sysuser,hostname,opuser,chgMark)
9 select xhjm,xm,xjztdm,sfzh,current_timestamp,System_USER,HOST_NAME(),
10 user_name(),'After' from inserted
11
12
2 FOR UPDATE
3 AS insert into UmlChgXj
4 (xhjm,xm,xjztdm,sfzh,updatetime,sysuser,hostname,opuser,chgMark)
5 select xhjm,xm,xjztdm,sfzh,current_timestamp,System_USER,HOST_NAME(),
6 user_name(),'Before'from deleted
7 insert into UmlChgXj
8 (xhjm,xm,xjztdm,sfzh,updatetime,sysuser,hostname,opuser,chgMark)
9 select xhjm,xm,xjztdm,sfzh,current_timestamp,System_USER,HOST_NAME(),
10 user_name(),'After' from inserted
11
12