SQL Server Query : Host name -Instance Name - Edition - Version - Product Level

SELECT @@SERVERNAME

or


SELECT 
  SERVERPROPERTY('MachineName') AS ComputerName,
  SERVERPROPERTY('ServerName') AS InstanceName, 
  SERVERPROPERTY('Edition') AS Edition,
  SERVERPROPERTY('ProductVersion') AS ProductVersion, 
  SERVERPROPERTY('ProductLevel') AS ProductLevel; 
GO 


https://docs.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-2017