一个关于触发器的问题

[奇零草]

有两个完全一样的表，一个保存当前数据，一个保存历史数据。当用户修改当前数据成功时，自动将原来的记录保存到历史数据表。如何编写实现如上功能的触发器，请高手指点，谢谢！
假设当前数据表为Current(X, Y), 历史数据表为History(X, Y).

[奇零草]

谢谢，已经做出来了。

[paoluo]

try:

Create Trigger Insert_Y On X
For Update
As
Insert Y Select * From Deleted
GO

[-狙击手-]

假设当前数据表为Current(X, Y), 历史数据表为History(X, Y).
create trigger dd
on table current
for update
as

insert history select * from current where ....

[paoluo]

不好意思，看錯了

Create Trigger Insert_History On Current
For Update
As
Insert History Select * From Deleted
GO