如何从单个查询访问2个数据库 [英] How to access 2 database from a single query

问题描述

我有两个数据库，分别是"Firstdb"和"Seconddb"，Firstdb由表"Firstdb_TableName"组成，Seconddb由表"Seconddb_tableName"组成.

I have two databases namely ''Firstdb'' and ''Seconddb'',Firstdb consists of table ''Firstdb_TableName'' and Seconddb consists of table ''Seconddb_tableName''.

select code from Firstdb_TableName

UNION ALL

select country from Seconddb_tableName

当我尝试执行上面的代码时，我会收到一条错误消息
无效的对象名称" Seconddb_tableName"

when I tried to ececute the above code,I will get an error message
"Invalid object name ''Seconddb_tableName''"

推荐答案

使用 ^ ]

从 Firstdb.dbo.TableName中

Use the 3 part naming syntax[^]

select code from Firstdb.dbo.TableName
UNION ALL
select country from Seconddb.dbo.tableName

尝试一下.

Try this.

select code from [db_name1].dbo.table_name1

UNION ALL

select country from [db_name2].dbo.table_name2

这篇关于如何从单个查询访问2个数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！