小弟有两个表 比如 deleteTb,insertTb 两个表滴结构完全一样
要实现滴弄能是 把从deleteTB表删除滴数据插入到insertTb中。就是为了备份删除滴数据。删除时根据id删除
因为公司就想要实现此方法。
请问大虾们 select语句应该怎么写啊?小弟真滴好急?
要实现滴弄能是 把从deleteTB表删除滴数据插入到insertTb中。就是为了备份删除滴数据。删除时根据id删除
因为公司就想要实现此方法。
请问大虾们 select语句应该怎么写啊?小弟真滴好急?
--这样?
insert into insertTb select * from deleteTB
delete deletetb
deleteTb FOR DELETE
INSERT insertTb SELECT * FROM DELETED
触发器比较好整
SELECT 不知道怎么整
create trigger del_deleteTb on deleteTb
for delete
as
insert into insertTb
select * from deleted
Delete from deleteTB where id=.... -- 再删除
after DELETE
as
INSERT insertTb
SELECT * FROM DELETED
create trigger del_deleteTb on deleteTb
for delete
as
insert into insertTb select * from deleted
Delete from deleteTB where id=.... -- 再删除
--还是用的触发器比较好
CREATE TRIGGER TRI_Del ON
deleteTb FOR DELETE
INSERT insertTb SELECT * FROM DELETED
create trigger del_deleteTb on deleteTb
for delete
as
insert into insertTb select * from deleted