Use Server name with database

Question

Hi, How I can USE command with Server name and with database?

Use <Servername>.<DataBase>

Answer 1

The T-SQL USE statement only allows a database name specification. It is up to the client application or tool to connect to the desired server before executing USE.

SSMS (in SQLCMD mode) and the SQLCMD utility provide a CONNECT command to dynamically change the database connection. You can include a CONNECT command in scripts executed with these tools. The server and database context reverts back to the initial server and database after script execution For example:

:CONNECT .
USE master;
SELECT @@SERVERNAME AS CurrentServer, DB_NAME() AS CurrentDatabase;
GO

Answer 2

You can't.

<servername> is a property of a connection to a MS SQL Server instance.
Just after you already connected to an instance, you can use T-SQL:
USE <database>;

Official documentation: use-transact-sql