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