Get my database server with current database.

This is a very simple use of SQL Server global variables. Microsoft SQL Server provides a massive number of global variables, which are very effective to use in our regular Transact-SQL. Global variables represent a special type of variable. The server always maintain the values of these variables. All the global variables represent information specific to the server or a current user session.

Global variable names begin with a @@ prefix. You do not need to declare them, since the server constantly maintains them. They are system-defined functions and you cannot declare them.

The following transact-sql can be use for to Get the Server and Current database as well.

SELECT 'My Server is: ' + @@servername  AS DBServer
SELECT 'My Current Database is: ' +  db_name()  AS CurrentDataBase

For more information can be found at this link.[^]