select 指令,可以查詢到二個不同資料庫中,各一個table的內容出來嗎?

https://social.technet.microsoft.com/Forums/zh-TW/3990d6ee-a25c-4be0-a6f5-79ae433a8373/select-table?forum=sqlservermanagementzhcht

可利用union all：

declare @cno char(6)

set @cno='CU0001'

select CNO,A01 as C01 from [甲].[dbo].[AA] where CNO=@cno

union all

select CNO,B01 as C01 from [乙].[dbo].[BB] where CNO=@cno