How to get the SQL Server features using a simple query?

Easy to do, just execute the following query:

DECLARE @edition sysname

      SET @edition = cast(SERVERPROPERTY(N'EDITION') as sysname)

   

SELECT

CAST(

        serverproperty(N'Servername')

       AS sysname) AS [Server_Name],

'Server[@Name=' + quotename(CAST(

        serverproperty(N'Servername')

       AS sysname),'''') + ']' AS [Server_Urn],

CAST(case when @edition = N'SQL Azure' then 2 else 1 end AS int) AS [Server_ServerType],

(@@microsoftversion / 0x1000000) & 0xff AS [VersionMajor],

(@@microsoftversion / 0x10000) & 0xff AS [VersionMinor],

@@microsoftversion & 0xffff AS [BuildNumber],

CAST(SERVERPROPERTY('IsSingleUser') AS bit) AS [IsSingleUser],

CAST(SERVERPROPERTY(N'Edition') AS sysname) AS [Edition],

CAST(SERVERPROPERTY('EngineEdition') AS int) AS [EngineEdition]

ORDER BY

[Server_Name] ASC

Results: