用sp_addlinkedserver 'sevEng','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=61.130.8...;UID=news;PWD=news;'
来接连
用 sp_addlinkedsrvlogin 来登陆@rmtsrvname='Doro',@useself='false',@locallogin='news',@rmtuser='news',@rmtpassword='newsPap'
然后再
select * from b.databasename.tablename...
来接连
用 sp_addlinkedsrvlogin 来登陆@rmtsrvname='Doro',@useself='false',@locallogin='news',@rmtuser='news',@rmtpassword='newsPap'
然后再
select * from b.databasename.tablename...
select * from dataname.dbo.tablename
這個是在不同的服務器和不同的數據庫中訪問某個表。
select * from dataserver.dataname.dbo.tablename
或
select * from [192.168.23.5].dataname.dbo.tablename