SQL跨数据库数据导入实例

--Step 1：
exec sp_configure 'show advanced options',1
  reconfigure
  exec sp_configure 'Ad Hoc Distributed Queries',1
  reconfigure

--Step 2：
INSERT INTO [***].[dbo].[Gen_Product]
           ([Insure_ID]
           ,[ProductType]
           ,[SubType]
           ,[MaxDay]
           ,[Prefix]
           ,[BasicInd])
     select [Insure_ID]
           ,[ProductType]
           ,[SubType]
           ,[MaxDay]
           ,[Prefix]
           ,[BasicInd] from 
OPENDATASOURCE('SQLOLEDB','Data Source=192.168.203.110;User ID=sa;Password=123').[123_DEV].dbo.[Gen_Product]
GO

转载于:https://www.cnblogs.com/captainR/p/3407115.html