Check SQL-Server Version using Query

With the help of below query you can find the SQL-Server Version and other details.

SELECT SERVERPROPERTY('productversion') AS VERSION, 

  SERVERPROPERTY ('productlevel') AS ServicePack, 

  SERVERPROPERTY ('edition') AS Edition

OR

SELECT @@version