22,210
社区成员
发帖
与我相关
我的任务
分享将一个表的一行删到另一个表的触发器怎么写?
怎么创建这样一个触发器，当删除一个表的一条记录时，把它插入到另一个表中。这两个表具有相同的结构。
...全文
请发表友善的回复…
发表回复
General521 2004-06-20
- 打赏
- 举报
create trigger trigger1
on table1
for delete
as
insert into table2
select * from deleted
go
on table1
for delete
as
insert into table2
select * from deleted
go
victorycyz 2004-06-18
- 打赏
- 举报
insert table2 select * from deleted
zjmym 2004-06-17
- 打赏
- 举报
USE databasename
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'TRIGGER1' AND type = 'TR')
DROP TRIGGER reminder
GO
CREATE TRIGGER TRIGGER1
ON tablename1
FOR delete
AS
select * into tablename2 from deleted
GO
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'TRIGGER1' AND type = 'TR')
DROP TRIGGER reminder
GO
CREATE TRIGGER TRIGGER1
ON tablename1
FOR delete
AS
select * into tablename2 from deleted
GO
