Here is a super simple query that will get you your current SQL Server version. Enjoy!
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
SELECT 'SQL Server ' + CASE CAST(SUBSTRING(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(100)), 1, CHARINDEX('.', CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR(100)))-1) AS INT) WHEN 8 THEN '2000' WHEN 9 THEN '2005' WHEN 10 THEN '2008' WHEN 11 THEN '2012' WHEN 12 THEN '2014' END + ' ' + CASE CAST(SERVERPROPERTY('ProductLevel') AS VARCHAR(100)) WHEN 'RTM' THEN '' ELSE CAST(SERVERPROPERTY('ProductLevel') AS VARCHAR(100)) + ' ' END + CAST(SERVERPROPERTY('Edition') AS VARCHAR(100)) AS SQLServerVersion |