Ameer Khan

SELECT
SERVERPROPERTY(‘MachineName’) AS HostName
,SERVERPROPERTY(‘InstanceName’) AS InstanceName
,SERVERPROPERTY(‘Edition’) AS EditionInfo
,SERVERPROPERTY(‘EditionId’) AS EditionID
,SERVERPROPERTY(‘ProductVersion’) AS ProductVersion
,SERVERPROPERTY(‘ProductLevel’) AS ProductType
,SERVERPROPERTY(‘EngineEdition’) AS EngineEdition
,SERVERPROPERTY(‘ResourceLastUpdateDateTime’) AS ResourceLastUpdateDateTime
,SERVERPROPERTY(‘IsClustered’) as IsClustered

Description:-
MachineName:- It shows  the hostname of the machine.
InstanceName:- It shows instance name if it is not default.In case of default it returns Null.
Edition :- It SQL Server edition installed on machine.
EditionId:- It shows Edition Id
ProductVersion:- It shows Product version.
ProductLevel:- It shows Level of the version of SQL Server instance
‘RTM’ = Original release version
‘SPn’ = Service pack version
‘CTP’, = Community Technology Preview version
EngineEdition:- It shows the engine edition.
1 = Desktop
2 = Standard
3 = Enterprise
4 = Express
5 = SQL Azure
ResourceLastUpdateDateTime:- It shows the date and time when the Resource database was last updated.
IsClustered:- It shows if  instance is configured in a failover cluster.
1 = Clustered.
0 = Not Clustered.
NULL = Input is not valid, or an error.