determine installed mssql server version code example

Example: how to know the sql server edition

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')