数据备份的问题 表A每删一条数据,触发器就把数据插到另一个表B中(表A删除是程序控制的,删几条也不一定)不知道这个触发器要怎么写,我自己的理解,它已经脱离程序的控制,就是在监听表的动作 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create trigger tir_del on tafor deleteas insert tb select * from deleted create trigger delete_inserton afor deleteasinsert into bselect * from deleted CREATE TRIGGER tr_1ON TABLEAFTER DELETEAS BEGIN INSERT INTO BAK_TABLE SELECT ... FROM DELETEDENDGO create trigger tri_g on 表1after deleteasbegininsert into 表2(字段..) select 字段.. from deletedend create trigger f_del on tafor deleteas insert tb select * from deleted create trigger tri_g on 表1after deleteasbegininsert into 表2(字段..) select 字段.. from deletedend 关于Group by的select语句写法 怎样在选择的列中增加一自动增加的列? 要查询某个字段内容重复出现的所有记录,怎样写SQL语句? 关于删除问题! 请问存储过程中的if语句该如何写? 请教SQL字段数字补位语句 请问这样的语名在sql 中如何循环使用? 索引服务的问题 (全文检索) 为什么不准 请教一个简单的SQL语句? 求一个SQL语句。 --悲哀:写文档的技术太差了,大家看看:有哪里说的不对的地方,帮我改正!先谢谢了!-- LDM文件格式是什么文件?用什么软件可以打开。
for delete
as
insert tb select * from deleted
on a
for delete
as
insert into b
select * from deleted
CREATE TRIGGER tr_1
ON TABLE
AFTER DELETE
AS
BEGIN
INSERT INTO BAK_TABLE
SELECT ...
FROM DELETED
END
GO
create trigger tri_g on 表1
after delete
as
begin
insert into 表2(字段..) select 字段.. from deleted
end
for delete
as
insert tb select * from deleted
create trigger tri_g on 表1
after delete
as
begin
insert into 表2(字段..)
select 字段.. from deleted
end