find out server name ,hostname and instance details + SQL Server

The below system functions, system variables and system procedure gives the basic info of the server

select serverproperty('servername'), @@servername ServerName
select serverproperty('machinename'), HOST_name() HostName 
select @@version
exec xp_msver -- to all details about MSSQL