数据库跨库连接,插入操作。

  

INSERT INTO [DB_Division].[WinEncash_2017]
SELECT *
FROM OPENROWSET('SQLOLEDB ', '10.44.1.1\\MSSQLSERVER2016'; 'sa '; '123456 ', JS_ConsigneeManageQuery.[DB_Division].[WinEncash_2017]);


SELECT * FROM JS_ConsigneeManageQuery.[DB_Division].[WinEncash_2017]


SELECT * FROM [JS_ConsigneeManage].[DB_Division].[WinEncash_2017]

posted @ 2017-12-29 17:42  icon_haru  阅读(431)  评论(0)    收藏  举报