There are several Methods to get Edition of Microsoft SQL Server or any other details But moat common is Hitting SQL Query :

"select serverproperty('Edition')"




OR get Edition Id which can be used in others process .

"select serverproperty('EditionID')"
Below are the ID 
-1253826760 = Desktop
-1592396055 = Express
-1534726760 = Standard
1333529388 = Workgroup
1804890536 = Enterprise
-323382091 = Personal
-2117995310 = Developer
610778273 = Enterprise Evaluation
1044790755 = Windows Embedded SQL
4161255391 = Express with Advanced Services


Thanks Hope this Helped you for any query please comment below.




SOURCE : JUST2CODE.IN Subscribe to our YouTube channel : https://www.youtube.com/user/TheRussell2012