触发器实现[修改或删除记录]备份一问？在线等~

[SDLin]

CREATE TRIGGER Group_History

ON GroupLocalArrange

FOR UPDATE or DELETE

AS

INSERT INTO GroupLocalHistory(id,groupID,localDate,localTraffic,gatherPlace,residence,eat)

SELECT id,groupID,localDate,localTraffic,gatherPlace,residence,eat FROM GroupLocalArrange

由于只想备份修改或删除的那条当前记录，所以这里需要一个参数

例：
where GroupLocalArrange.id = '1'

如何把这个参数导入近来？迷茫......

[netcoder]

这样写:

CREATE TRIGGER Group_History

ON GroupLocalArrange

FOR UPDATE or DELETE

AS

INSERT INTO GroupLocalHistory(id,groupID,localDate,localTraffic,gatherPlace,residence,eat)

SELECT id,groupID,localDate,localTraffic,gatherPlace,residence,eat FROM deleted

[SDLin]

Thank you !