Check version information in SQL Server

This article will show you in detail how to use the @@ VERSION query to check the information that SQL Server version is using.

Describe

Query @@ VERSION is used to determine the version of SQL Server you are using with the same operating system information.

Syntax

To use the VERSION function in SQL Server, we use the following syntax:

 @@VERSION 

There are no parameters and arguments in the statement.

Note :

• VERSION can be used in later versions of SQL Server: SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, and SQL Server 2008.

For example

To check the information the SQL Server version is using, we run the query:

 SELECT @@VERSION; 

Results returned:

 Microsoft SQL Server 2017 (RTM-CU3-GDR) (KB4052987) - 14.0.3015.40 (X64) 

• Microsoft SQL Server 2017: SQL Server product name
• KB4052987: article describing the update
• 14.0.3015.40: version number
• X64: 64-bit version of SQL Server.

Previous article: TRY_CONVERT function in SQL Server

Next lesson: CASE function in SQL Server