SQL @@SERVERNAME is one of the Configuration Function, which will return the local server name that is currently running SQL Server. Syntax behind this is
|
1 |
@@SERVERNAME |
SQL @@SERVERNAME Example
Below code snippet will show you the instance of the SQL Server that we are currently using.
|
1 |
SELECT @@SERVERNAME AS 'Server Name' |
OUTPUT
Thank You for Visiting Our Blog
Share your Feedback, or Code!!