The @@SERVERNAME is one of the Configuration Functions, which will return the local server name that is currently running SQL Server. Syntax behind this is
@@SERVERNAME
The below code snippet will show you the instance of the SQL Server that we are currently using.
SELECT @@SERVERNAME AS 'Server Name'
