两个分开导: insert into database3.dbo.tb1 select * from database1.dbo.tb1 where id not in(select id from database3.dbo.tb1) insert into database3.dbo.tb1 select * from database2.dbo.tb1 where id not in(select id from database3.dbo.tb1)
insert db3.dbo.tb select * from ( select * from db1.dbo.tb union all select * from db2.dbo.tb)T
insert into database3.dbo.tb1 select * from database1.dbo.tb1
where id not in(select id from database3.dbo.tb1) insert into database3.dbo.tb1 select * from database2.dbo.tb1
where id not in(select id from database3.dbo.tb1)
select * from (
select * from db1.dbo.tb
union all
select * from db2.dbo.tb)T
我想把前两个库中所有'A'+日期打头的表(如a081128_cell)都COPY到TEMP库中
怎么替换你们说的命令,我有点看不太懂
2:是將GSM,BAK庫中對應表數據合併後,插入到TEMP?
对了。。导出数据里面不是有‘追加数据’那个选项吗,我问下这个选项我勾上以后,能实现我想要的效果吗?