How to Find Version Information in SQL Server?

Hello everyone,

In this article, I will give information about how to learn version information in SQL Server.

In SQL Server, in some cases, you may want to learn the version information.

There are several ways to find out.

The first way

SELECT @@VERSION

is to run the statement.

As you can see, the version information has arrived.

The second way is to right click on Object Explorer while in SQL Server Management Studio and select Properties.

After clicking Properties, you can see the version information in the section below.

The third way is

SELECT SERVERPROPERTY('ProductVersion')

is to run the code in SQL Server Management Studio.

• 8 = SQL 2000
• 9 = SQL 2005
• 10 = SQL 2008 (and 10.5 = SQL 2008R2)
• 11 = SQL 2012
• 12 = SQL 2014
• 13 = SQL 2016
• 14 = SQL 2017
• 15 = SQL 2019

You can find which version of SQL Server you are using from the version numbers above.

Good luck to everyone in business and life.