摘要:
insert into Aselect A.ID,A.NAME from opendatasource('SQLOLEDB','Password=123;Persist Security Info=True;User ID=sa;Data Source=192.168.2.138').DBNAME.TABLENAMEEXECsp_addlinkedserver@server='DBVIP',--被访问的服务器别名(任意的名称)@srvproduct='',@provider='SQLOLEDB',@datasrc= 阅读全文