摘要:
--简单的跨服务器查询语句select * from opendatasource('SQLOLEDB', 'Data Source=192.168.0.1;User ID=sa;Password=123').db_bingle.dbo.users--跨服务器插入数据IF EXISTS (select * from sys.servers WHERE name = 'ufserver')Exec sp_droplinkedsrvlogin 'ufserver',Null exec sp_dropserver @server= 阅读全文