如何从sql语句或存储过程连接到外部数据库？

分类: 技术问答 • 2022-04-22 09:06:10

问题描述：

在数据库上运行SQL语句或存储过程时，您是否可以连接到外部数据库并从中提取数据？

When running a SQL statement or a stored procedure on a database, can you connect to an external database and pull data from there?

如下：

SELECT a.UserID, b.DataIWantToGet 
  FROM mydb.Users as a, externaldb.Data as b

答

您需要设置链接服务器实例。然后可以引用外部数据库，就像它是一个SQL Server数据库。

You'll need to setup a Linked Server instance. Then you can reference the external database as though it were a SQL Server database.