SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[sql-server] How do you join tables from two different SQL Server instances in one SQL query

Possible Duplicate:
Selecting data from two different servers in SQL Server

How can I join two tables, which are located two different SQL Server instances, in one query?

This question is related to sql-server join multiple-instances

The answer is

If you are using SQL Server try Linked Server

You can create a linked server and reference the table in the other instance using its fully qualified Server.Catalog.Schema.Table name.

Source: Stackoverflow.com

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to join

• Pandas Merging 101 • pandas: merge (join) two data frames on multiple columns • How to use the COLLATE in a JOIN in SQL Server? • How to join multiple collections with $lookup in mongodb • How to join on multiple columns in Pyspark? • Pandas join issue: columns overlap but no suffix specified • MySQL select rows where left join is null • How to return rows from left table not found in right table? • Why do multiple-table joins produce duplicate rows? • pandas three-way joining multiple dataframes on columns

Examples related to multiple-instances

• Calling another method java GUI • How do you join tables from two different SQL Server instances in one SQL query