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.
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
- Instructions on how to check the PHP version
- How to check the version of Excel in use
- How to check the version of macOS in use
- How to view the version of Word in use
- How to Check PHP Version on Server
- Learn about ES6 in Javascript
- How to check the current Driver version of the computer
- How to Check PHP Version
- DAY function in SQL Server
- How to check your Linux version
- MIN function in SQL Server
- MAX function in SQL Server
Maybe you are interested
15 best bots to improve Discord server
How to download Free Fire OB46 Advance Server trial version
Serious vulnerability in OpenSSH threatens millions of servers
When was Free Fire Advance Server OB45 released? How to download and play FF Advance OB45
After being fired, the former employee deleted 180 of the old company's servers
How to download Free Fire OB45 trial version, FF Advance Server