一个嵌套的的存储过程问题！！！！！

[outiejun]

我有两个表
news:
id title body
backupnews:
id title body

现在我要利用一个存储过程实现以下的操作：

将news中的一个记录备份到backupnews表中，然后在news表中删除.

请问我该怎么写呢？谢谢

[CrazyFor]

insert into backupnews
select * from news where XXXXXXX

delete news where id in (select id from backupnews)

[lang_ren]

用触发器不是更好吗？

create trigger trig_a on news after delete
as
begin
insert backupnews select * from deleted
end

[CrazyFor]

backupnew的ID字段用INT类型，不要是自增字段。

[愉快的登山者]

insert into backupnews
select * from news where id not in (select id from backupnews)

delete news where id in (select id from backupnews)

[outiejun]

感谢，结账！