Query across multiple databases on same server

May 12, 2023 by Tarik

You must specify the database name before any database object.

Single database:

SELECT * FROM [dbo].[myTable]

Multiple dabases:

SELECT * FROM [DB01].[dbo].[myTable]
UNION ALL
SELECT * FROM [DB02].[dbo].[myTable]
UNION ALL
SELECT * FROM [DB03].[dbo].[myTable]