触发器简单问题:如何删除多条记录时将删除的ID保存到另一个表里面100分! create trigger tri_yourTable on yourTablefor deleteas insert into otherTable(id) select id from deleted 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 最好不用游标create trigger tri_test_delete on test_f after deleteasbegin insert test_a (id) select id from deletedendgo 先谢谢楼上的,如果往del_history表里面插入ID和删除记录的表的表名怎么做?例如:删除a表三条记录触发器:插入del_history表(id,tablename)该三条记录的id和a(插入到tablename里面)怎样做? create trigger tri_test_delete on test_f after deleteasbegin insert test_a (id,tablename) select id,tablename='a'from deletedendgo create trigger tri_test_delete on yourTable after deleteasbegin insert test_a (id,tableName) select id,'yourTable' from deletedendgo 存储程序返回动态列的结果集插入到临时表中 SQL2008管理工具怎么安装,下载了安装不来 MySQL导入到SQLServer2005中,汉字都变成了??? 各单位计算机数量的统计 sql中日期轉換 【求助】使用bulk insert时出现错误 K3万能报表手工输入查询单据编号再模糊查询的问题 sql 2000 sp4能降级到sp3吗 请问各位大虾一个问题! SQL SERVER 死锁问题,请大神指点 为什么我的sql2000桌面版报错如"要在win32下运行"等(98下)?也请推荐D盘(名字) 如何输入image数据
create trigger tri_test_delete on test_f after delete
as
begin
insert test_a (id) select id from deleted
end
go
例如:删除a表三条记录
触发器:插入del_history表(id,tablename)该三条记录的id和a(插入到tablename里面)
怎样做?
as
begin
insert test_a (id,tablename) select id,tablename='a'from deleted
end
go
as
begin
insert test_a (id,tableName) select id,'yourTable' from deleted
end
go