Queries in the same window for multiple databases, servers, and tables

Question

I was wondering in SSMS in the query window could I write multiple queries that use different servers, databases, and tables?

A compounded question and answer I am expecting for this.

Answer 1

because SSMS supports the go command, you can use different batches to query different database without having to include the database name in the query (no help for linked servers).

use database1
go

select * from table1
go

use database2
go

select * from table2
go

Answer 2

You can use 3-part qualifier to access different databases on the same SQL Server like

SELECT * FROM Database.Schema.Table

and "Linked Server" to access different SQL Server, see

https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver16

Answer 3

If you want to query multiple servers there is one option that is a little on the advanced side. In SSMS, find Registered Servers in the View menu. In this window you can define groups of servers. You can then right-click a group and select New Query. SSMS will now run your queries in all servers in the server group. You get the server name in an extra column in the result set.