get sql server version 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')

Example 4: sql server version query

SELECT @@VERSION