Capturing the Edition based on
ID of Currently Running SQL Server
In this blog we see, How to Capture
the Edition based on ID of Currently Running SQL Server
3. 64-bit
versions of the Database Engine append (64-bit) to the version.
Overall List of Edition of SQL Server
1804890536 = Enterprise
1872460670 = Enterprise
Edition: Core-based Licensing
610778273= Enterprise
Evaluation
284895786 = Business
Intelligence
-2117995310 = Developer
-1592396055 = Express
-133711905= Express with
Advanced Services
-1534726760 = Standard
1293598313 = Web
Syntax:
SERVERPROPERTY ( propertyname
)
Usage:
Base data type:
OUTPUT: It is based on your SQL server installed