两台SQL数据库数据间的读取和插入问题。

Question

insert 本地库名..表名 from OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=远程ip;User ID=sa;Password=密码'
         ).库名.dbo.表名

Answer 1

我用以下SQL语句却提示from 附近有语法错误，请再指教
insert  TagStation.dbo.OpenETC from OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=192.168.0.124;User ID=etc;Password=etc'
         ).TagStagtion.dbo.OpenETC

Answer 2

insert TagStation.dbo.OpenETC select * from OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=192.168.0.124;User ID=etc;Password=etc'
         ).TagStagtion.dbo.OpenETC

Answer 3

我粗心了，写成以下即可
insert  TagStation.dbo.OpenETC Select * from OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=192.168.0.124;User ID=etc;Password=etc'
         ).TagStagtion.dbo.OpenETC