Delete from OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.20;User ID=binladen;Password=binladen_Password'
).[DBTest].dbo.职务
Select * From OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.9;User ID=binladen;Password=binladen_Password'
).[DBTest_2].dbo.试题
Insert Into OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.20;User ID=binladen;Password=binladen_Password'
).[DBTest].dbo.职务
Select * From 职务;
Insert Into 职务 Select * From OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.1.20;User ID=binladen;Password=binladen_Password'
).[DBTest_2].dbo.职务;
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure