如何在SQL中连接两个数据库？

问题描述：

您好..

我想知道如何在SQL中连接两个数据库。

示例1： SQL数据库A到SQL数据库B

示例2： SQL数据库A到Oracle或任何其他数据库。

请帮帮我..

先谢谢..

Hello..

I want to know how to connect two database in SQL.

Example1: SQL Database A to SQL Database B

Example2: SQL Database A to Oracle or any other Database.

please help me..

Thanks in Advance..

答

以下链接对于连接两个DB很有用/>
http://forums.asp.net/t/1254974.aspx?How+to+join+tables+from+different+databases+in+SQL+select+statement+ [ ^ ]

below link is usefull to connect two DB
http://forums.asp.net/t/1254974.aspx?How+to+join+tables+from+different+databases+in+SQL+select+statement+[^]

试试这个：

Try this:

SELECT a.userID, b.usersFirstName, b.usersLastName  FROM databaseA.dbo.TableA a inner join database B.dbo.TableB b  ON a.userID=b.userID

您不能直接在飞行中这样做。你有两个选择：

1.在DB环境中创建一个链接服务器，然后创建一个SP来处理它。

2.为它们获取两个DataSet，然后基于usersID将两个数据表合并为一个。

如果这样可以解决您的问题，请将其标记为解决方案..谢谢..

You can't do that on fly directly. You have two options:
1. Create a linked server in DB invironment, then create a SP to take care of it.
2. Get two DataSets for them, then merge two datatables into one based on usersID.
If this solves your issue kindly up vote and mark this as solution.. Thanks..

如何在SQL中连接两个数据库？

相关推荐