i new sql server database.
i have 2 databases db1(table t1 therein db) , db2(table t2 therein db) in same sql server. want join t1 , t2 in sql server. came across concept called dblink. can create db link in scenario(if yes, please let me how create it.)?
thanks in advance.
dblink feature of oracle, not sql server. corresponding feature ins mssql called linked servers, , enables add links different server, not database. in case, don't need this. join tables different databases on same server, include database name in query:
select top 100 t1.* [databse_name].[schema_name].[table_name] t1
Comments
Post a Comment