FIND SQL Server Version with SQL Query

December 23, 2019March 3, 2009 by PaddyMaddy

SELECT LTRIM(RIGHT(LEFT(@@VERSION,38),9))
SELECT 'SQL Server '

+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' – '

+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('

+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

——————-
Thanks,
https://sccm07.blogspot.com/