Home
Wifi Tips
Fix Computer
Windows 10
Windows 11
Artificial Intelligence
Space Science
Strange story
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
You've just finished reading the article "Check version information in SQL Server" edited by the TipsMake team. You can save check-version-information-in-sql-server.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.
Lesley Montoya