insert into A
select A.ID,A.NAME from
opendatasource('SQLOLEDB','Password=123;Persist Security Info=True;User ID=sa;Data Source=192.168.2.138').DBNAME.TABLENAME
insert into A
select A.ID,A.NAME from
opendatasource('SQLOLEDB','Password=123;Persist Security Info=True;User ID=sa;Data Source=192.168.2.138').DBNAME.TABLENAME