关于SQL跨库查询

Question

SELECT  TOP 10 * FROM [10.0.0.1].[name].dbo.table该数据库需要加用户名和密码访问，请问该怎么写？

Answer 1

Select TableA.*,TableB.* From OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=ServerA;User ID=UserID;Password=Password'
         ).databaseAName.dbo.TableA 
Left Join 
 OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=ServerB;User ID=UserID;Password=Password'
         ).databaseBName.dbo.TableB On TableA.key=TableB.key 
http://www.cnblogs.com/daniel206/archive/2008/01/16/1041748.html

Answer 2

谢谢，你的链接我收藏了，周末好好看看，thank you!