sql server version check code example

Example 1: sql version query

SELECT @@VERSION AS 'SQL Server Version';

Example 2: sql server check version

SELECT @@version

Example 3: how to know the sql server edition

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