Getting the Version Information and Cumulative Update Status in SQL Server

Hello everyone,

In this article, I will try to give information about the version information and cumulative update status in SQL Server.

In SQL Server, in some cases, you may want to know the version information and batch cumulative status.

You can easily do this using the codes below.

SELECT LEFT(@@version, 25) AS 'SQL Version',
       SERVERPROPERTY('ProductUpdateLevel') AS 'ProductUpdate Level';

When you run the above codes, you will see a result similar to the one below.

As you can see, we have learned the version information and the cumulative update status.

Good luck to everyone in business and life.