怎样编写触发器！一个很简单的触发器

[lvgefeng]

有两张表table1，table1history，两张表的结构完全相同，现在需要编写一个触发器，每当对table1进行update操作时就将table1中修改的记录插入到table1history中去

[txlicenhe]

create trigger 名 on table1
for update
as
update a set a.f1 = b.f1,a.f2 = b.f2...
from tablehistory a
join inserted b on a.主键 = b.主键

[txlicenhe]

或
create trigger 名 on table1
for update
as
insert tablehistory select * from inserted

[wzh1215]

create trigger 名 on table1
for update
as
insert tablehistory select * from deleted

[rocllllll]

果然是一个很简单的触发器

[sunsunup]

樓主: 修改的記錄可以插到舊表中, 刪除的記錄怎樣處理? 要先給一個解決方案才行.

[yoki]

create trigger 名 on table1
for update
as
insert tablehistory select * from inserted