How to know MS SQL Server Version

There are different ways to know the SQL Server Version.

You can use the following sql statements to know the Sql Server Version:

SELECT @@VERSION AS SQLVERSION /*Gives the complete information of sql edition and version*/

SELECT SERVERPROPERTY('ProductVersion')AS SqlVersion, SERVERPROPERTY('Edition')AS SqlEdition, SERVERPROPERTY('ServerName')AS SQLServerName

SELECT 'Microsoft SQL Server ' + CAST(SERVERPROPERTY('EDITION')AS VARCHAR(100)) + ' ' + CAST(SERVERPROPERTY('PRODUCTLEVEL')AS VARCHAR(50)) AS SqlServerVersion

You can use the other values to know more information using SERVERPROPERTY function.

You can also use the following stored procedures to know the Sql Server version Information.

EXEC xp_msver
EXEC sp_msGetVersion