Query for finding the SQL server information

select
serverproperty('Edition') EDITION,
serverproperty('ComputerNamePhysicalNetBIOS') 'COMPUTER NAME',
serverproperty('InstanceName') 'INSTANCE NAME',
serverproperty('IsClustered') 'IS CLUSTERED',
serverproperty('MachineName') 'Machine name',
serverproperty('ProductVersion') 'SQLPRODUCT VERSION',
serverproperty('ProductLevel') 'PRODUCT LEVEL',
serverproperty('ServerName') 'Server Name'
GO