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
4 ★ | 2 Vote
You should read it
May be interested
- CASE statement in SQL Serverthis article will show you in detail how to use the case statement handling function in sql server with specific syntax and examples to better visualize and capture functions.
- COALESCE statement in SQL Serverthe coalesce statement returns the expression with the first non-null value among the passed expressions.
- CURRENT_USER statement in SQL Serverthe current_user statement returns the name of the current user in the sql server database.
- ISDATE function in SQL Serverthe isdate function in sql server checks to see if the expression passed is a valid time value, if isdate returns 1, otherwise it returns 0.
- ISNULL function in SQL Serverin sql server, the isnull function allows you to return an alternate value when an input expression is null.
- ISNUMERIC function in SQL Serverthe isnumeric function in sql server checks whether the value of the passed expression is a valid numeric value, if there is isnumeric returns 1, otherwise it returns 0.