关于SQL跨库查询

SELECT TOP 10 * FROM [10.0.0.1].[name].dbo.table

该数据库需要加用户名和密码访问，请问该怎么写？
Asp.netC#
zoorgeDyeno -
  • affopoumb - 3个月前

    引用 2 楼 q107770540 的回复:

    SQL code

    Select TableA.*,TableB.* From OPENDATASOURCE(
    'SQLOLEDB',
    'Data Source=ServerA;User ID=UserID;Password=Password'
    ).databaseAName.dbo.TableA
    Left Join
    OPENDATA……




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

  • strangle - 3个月前

    SQL code 

    
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