SQL Server Transact Basic to Expert - Get Current SQL Server Instance Name

This blog shows how to get the current sessions Server Instance name in SQL Server

Example:

SELECT @@SERVERNAME Server Name