触发器简单问题：如何删除多条记录时将删除的ID保存到另一个表里面100分！

[I_wanttoknow]

弟兄们，帮帮忙，我第一次写触发器，另请大家多谈谈游标的使用与注意事项，谢谢

[IronPromises]

create trigger tri_yourTable on yourTable
for delete
as
insert into otherTable(id) select id from deleted

[蓝天]

最好不用游标
create trigger tri_test_delete on test_f after delete
as
begin
insert test_a (id) select id from deleted
end
go

[I_wanttoknow]

先谢谢楼上的，如果往del_history表里面插入ID和删除记录的表的表名怎么做？
例如：删除a表三条记录
触发器：插入del_history表（id,tablename）该三条记录的id和a(插入到tablename里面)
怎样做？

[strongsun]

create trigger tri_test_delete on test_f after delete
as
begin
insert test_a (id,tablename) select id,tablename='a'from deleted
end
go

[hjhing]

create trigger tri_test_delete on yourTable after delete
as
begin
insert test_a (id,tableName) select id,'yourTable' from deleted
end
go

[I_wanttoknow]

谢谢大家了，结贴