如何用触发器将一个表新增加的行插入到另一个表中 我有两个表rdrecords和rdsbak,表结构完全一样,现在需要将rdrecords表中新增加的行自动增加到rdsbak中,应该怎样写触发器语句? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 CREATE trigger tr_in_up_rdrecords on dbo.rdrecords for insertas insert into rdrecords select * from inserted 我是最终要插入到rdsbak表中,不是rdrecords,这个语句好象不行吧? CREATE trigger tr_in_up_rdrecords on dbo.rdrecords for insertas insert into rdsbak select * from inserted create trigger my_trig on rdrecords for insertasbegin insert into rdsbak select * from insertedend CREATE trigger tr_rdrecords on dbo.rdrecords for insertas begin insert into inserted select * from rdrecordsendgo create trigger tri_name on rdrecords for insertasbegin insert into rdsbak select * from insertedend 关于一个SQL统计的问题 小弟有个问题请教~~ 关于not in的问题 求一语句 菜鸟级问题!!!!!!! 为什么我装SQL2005时老是说我的硬件配置低啊??急!!!高分求助!! sql2000数据库迁移问题 百分相送 数据库理论的一道题求答案! 怎样实现在SQLSERVER中保存图片?在线求助! 如何在win98中安装SQL SERVER2000 SQL查询问题 求语句格式转换 DATEDIFF SQL查詢語句
as insert into rdrecords select * from inserted
CREATE trigger tr_in_up_rdrecords on dbo.rdrecords for insert
as insert into rdsbak select * from inserted
as
begin
insert into rdsbak select * from inserted
end
on dbo.rdrecords for insert
as
begin
insert into inserted select * from rdrecords
end
go
as
begin
insert into rdsbak select * from inserted
end