Version Function in SQL Server: Check Version Information in SQL

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

Describe

Query @@ VERSION helps 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.

As an example,

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

 SELECT @@VERSION; 

Next lesson: CASE function in SQL Server