【数据处理】各门店销售数据导入

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