There are times where you might want to programmatically determine which edition of SQL Server is running. When I say “Edition” I don’t mean are you running SQL Server 2012, 2014, 2016, or some other major release of SQL Server. What I mean is are you running standard, enterprise, or developer edition.
To get the version of SQL Server programmatically there are a couple of different options. The first method I will show you is using the @@VERSION system function. This system function will provide you the system and build information for SQL Server. To use the @@VERSION function you can perform this Transact-SQL:
SELECT @@VERSION;
When I run this code, I get the following results from one of my SQL Server instances:
-----------------------------------------------------------------------
Microsoft SQL Server 2016 (RTM-GDR) (KB3194716) - 13.0.1722.0 (X64)
Sep 26 2016 13:17:23
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows 10 Home 6.3 <X64> (Build 14393: )
Another way to return what edition you are running is to use the SERVERPROPERTY function. This function accepts propertyname as a parameter. To return the version and edition information you can run the following code:
SELECT SERVERPROPERTY('ProductVersion') as [ProductVersion]
,SERVERPROPERTY('Edition') AS [Edition];
When I run this code the following output is displayed:
ProductVersion Edition
-----------------------------------------------------------------------
13.0.1722.0 Enterprise Edition (64-bit)
See all articles by Greg Larsen
» 