跨服务器快速导入数据表记录 Insert Select

懒笔头

于 2019-10-23 11:49:17 发布

阅读量214

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL

原文链接：https://blog.youkuaiyun.com/admans/article/details/83657999

SQL 专栏收录该内容

21 篇文章

订阅专栏

Use DataBaseName
 
/*开启Ad Hoc Distributed Queries组件
 
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
*/
 
 
 
Insert into tableName (col1，col2，col3，……) --字段不能含有主键
 
SELECT  col1，col2，col3，……
     
from opendatasource
(
    'SQLOLEDB',
    'Data Source=192.168.0.1;User ID=dbuser;Password=123456'
).DataBaseName.dbo.tableName 
WHERE [datetime]>'2016-11-01 15:00:18.663' 
AND [datetime]<'2016-11-01 15:00:18.663'
 
/*关闭Ad Hoc Distributed Queries组件
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure
*/