MSSQL Query Blog

21 December 2021

Listing 365 Days in SQL Server

Hello everyone, In this article, I will provide information about listing 365 days in SQL Server. In SQL Server you may want to list 365 days in some cases. You can easily do this using the code below. WITH mycte AS ( SELECT CAST(‘2021-01-01’ AS DATETIME) DateValue UNION ALL SELECT...

SQL Server

20 December 2021

SQL Server 2019 Versions

Hello everyone, In this article, I will give information about SQL Server versions. In SQL Server, you may need knowledge of SQL Server 2019 versions in some cases. You can easily learn your own version by using the list below. Version Versions Number KB Release Date CU-5 15.0.4043.16 KB4552255 Haziran...

SQL Server

19 December 2021

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...

SQL Server

11 December 2021

Last Day of Month in SQL Server

Hello everyone, In this article, I will give information about the last day of the month in SQL Server. In SQL Server, in some cases you may want to know the last day of the month. You can easily do this using the code below. SELECT ‘Last Day of the...

SQL Server

11 December 2021

Code to Create Compatibility Levels of All Databases in SQL Server

Hello everyone, In this article, I will provide information on how to generate the code to create the Compatibility Levels of all databases in SQL Server. In SQL Server, you may want to create the Compatibility Levels of all databases at once before and after the upgrade operations. You can...

SQL Server

8 December 2021

Last Day of Previous Month in SQL Server

Hello to everyone, In this article, I will provide information about the last day of the previous month in SQL Server. In SQL Server, in some cases you may want to know the last day of the previous month. You can easily do this using the code below. SELECT ‘Last...

SQL Server

5 December 2021

SQL Server Management Studio (SSMS) Versions List

Hello to everyone, In this article, I will provide information about the SQL Server Management Studio (SSMS) version list. In SQL Server, you may need SQL Server Management Studio (SSMS) version information in some cases. Using the list below, you can easily find out your own version information. SSMS VERSION...

SQL Server

4 December 2021

Finding the Last Time the SQL Server Service Started in SQL Server

Hello to everyone, In this article, I will provide information about finding the last time the SQL Server service started in SQL Server. In SQL Server, in some cases, you may want to know when the SQL Server service was last started. You can easily do this using the code...