insert into xbxs
select * from [192.168.1.100].[scmis].[dbo].mdxs
delete from [192.168.1.100].[scmis].[dbo].mdxs
insert into dbxs
select * from [192.168.2.102].[scmis].[dbo].mdxs
delete from [192.168.2.102].[scmis].[dbo].mdxs
insert into zqxs
select * from [192.168.4.100].[scmis].[dbo].mdxs
delete from [192.168.4.100].[scmis].[dbo].mdxs
insert into gdxs
select * from [192.168.0.2].[scmis].[dbo].mdxs
delete from [192.168.0.2].[scmis].[dbo].mdxs
【数据处理】各门店销售数据导入,布布扣,bubuko.com
原文:http://www.cnblogs.com/nlg3413/p/3897920.html