see sql server version code example

Example 1: sql server check version

SELECT @@version

Example 2: how to know the sql server edition

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