高手请教?

Question

insert into table1(field1,field2)
select field1,field2
from database2.table1

Answer 1

insert into database2.table2(field1,field2)
select field1,field2
from database1.table1

Answer 2

试试这个办法：
insert into table1(field1,field2)
-- SELECT from a table on another instance of SQL Server.
SELECT field1,field2
FROM OPENDATASOURCE(
          'SQLOLEDB',
          'Data Source=ServerName;User ID=MyUID;Password=MyPass'
                   ).database.dbo.table

Answer 3

OK????
这里的ServerName应该是ODBC名