34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER tr_dA ON A FOR
DELETE
AS
INSERT INTO a
SELECT * FROM deleted WHERE --可指定删除内容为条件
触发器这样用,表结构不一致时,自己指定列
--语句大体就是这样,你自己根据实际调整
create trigger tri_del on a for delete
as
insert into b select 字段列表 from deleted
--这样?
create trigger tri_del on a for delete
as
delete from a where 条件语句
insert into b select 字段列表 from deleted