How to get Host name and SQL Instance Name in T-SQL

Run

SELECT SERVERPROPERTY('MachineName') AS [ServerName],
       SERVERPROPERTY('ServerName') AS [ServerInstanceName],
       SERVERPROPERTY('InstanceName') AS [Instance],
       SERVERPROPERTY('Edition') AS [Edition],
       SERVERPROPERTY('ProductVersion') AS [ProductVersion],
       Left(@@VERSION, Charindex('-', @@VERSION) - 2) AS VersionName

or

SELECT @@SERVERNAME