数据集中操作脚本1（初始数据插入）

SELECT *  into dbo.TBL_ColorModel
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.161.100;User ID=sa;Password=kevin'
).WebErpBak.dbo.TBL_ColorModel

SELECT *  into dbo.TBL_Customer
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.161.100;User ID=sa;Password=kevin'
).WebErpBak.dbo.TBL_Customer

SELECT *  into dbo.TBL_InComeBill
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.161.100;User ID=sa;Password=kevin'
).WebErpBak.dbo.TBL_InComeBill

SELECT *  into dbo.TBL_InComeDetail
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.161.100;User ID=sa;Password=kevin'
).WebErpBak.dbo.TBL_InComeDetail

SELECT *  into dbo.TBL_Order
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.161.100;User ID=sa;Password=kevin'
).WebErpBak.dbo.TBL_Order

SELECT *  into dbo.TBL_OrderDrawOut
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.161.100;User ID=sa;Password=kevin'
).WebErpBak.dbo.TBL_OrderDrawOut

SELECT *  into dbo.TBL_Schema
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.161.100;User ID=sa;Password=kevin'
).WebErpBak.dbo.TBL_Schema

SELECT *  into dbo.TBL_SchemaDetail
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.161.100;User ID=sa;Password=kevin'
).WebErpBak.dbo.TBL_SchemaDetail

SELECT *  into dbo.TBL_StockMaterial
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.161.100;User ID=sa;Password=kevin'
).WebErpBak.dbo.TBL_StockMaterial

SELECT *  into dbo.TBL_SchemaColor
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.161.100;User ID=sa;Password=kevin'
).WebErpBak.dbo.TBL_SchemaColor