数据备份小问题
在表a里插入数据，怎样同步把数据也插到表b，
或者在插入时，将表a里已经存在相同id的数据移到表b里？

------解决方案--------------------
create trigger tr_a
on account
for insert
as
insert into b select * from inserted

------解决方案--------------------
--上面错了
create trigger tr_a
on a
for insert
as
insert into b select * from inserted
------解决方案--------------------
好！
------解决方案--------------------
similar answer is

HTTP://www.ebigear.com/Fund/PlayNews.php?NewsID=28501&ID=285885