如何在SQL中连接两个数据库？ [英] How to Connect two Database in 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中连接两个数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！