如果有A,B,C三个数据库,每个数据库中含有一张Test表,那么要一次查询三个数据库的Test表的信息该如何查询呢?
很简单!如下写法!
select
*
from
[
A
]
..test
union
select * from [ B ] ..test
union
select * from [ C ] ..test
union
select * from [ B ] ..test
union
select * from [ C ] ..test
做个笔记!供下次记不起来的时候翻阅!