SERVERPROPERTY is a system function in SQL Server that returns property details about the server instance, including the build version, collation, server name, instance name, edition presently installed, if it is clustered, product level, product version, etc.
Syntax:
SERVERPROPERTY ( ‘propertyname’ )
Example:
SELECT SERVERPROPERTY(‘productversion’),
SERVERPROPERTY (‘productlevel’),
SERVERPROPERTY (‘edition’),
@@VERSION
Hope you find this information useful.
Big Data & SQL 
One comment