Finding Version in SQL Server

Hello everyone,

In this article, you will learn about learning version information in SQL Server.

You can learn your SQL Server version information by using the code below.

SELECT CAST(SUBSTRING(
                         CAST(SERVERPROPERTY('productversion') AS VARCHAR(20)),
                         1,
                         CHARINDEX('.', CAST(SERVERPROPERTY('productversion') AS VARCHAR(20))) - 1
                     ) AS INT);

When you run the above code, you will see the following result.

We have seen the number 15.

You can find out your version according to your number from the web address below.

https://docs.microsoft.com/en-us/troubleshoot/sql/general/determine-version-edition-update-level

Good luck to everyone in business and life.