首页 > 代码库 > 【数据处理】各门店销售数据导入

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

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