SQL使用触发器,当删除数据时,先备份被删除的数据.

[zwfgdlc]

CREATE TRIGGER [test] ON [dbo].[tAdd] 
FOR  DELETE 
AS 
BEGIN
/*怎么把将要删除的数据先备份到另一个表中去,比如把tadd表中几个重要的字段,备份到另一个表去.*/
END

[geniuswjt]

CREATE TRIGGER [test] ON [dbo].[tAdd] 
FOR  DELETE 
AS 
BEGIN
    insert into tadd_bak(col1,col2,col3)
    select col1,col2,col3 from deleted
END

[--小F--]

[Quote=引用 1 楼 geniuswjt 的回复:]
SQL code


CREATE TRIGGER [test] ON [dbo].[tAdd]
FOR DELETE
AS
BEGIN
insert into tadd_bak(col1,col2,col3)
select col1,col2,col3 from deleted
END
[/Quote]
deleted 触发器