MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will give you information on how to find the start and end dates of all the weeks between two dates in SQL Server. Let me tell you from the beginning, the following query works based on the week start date you have determined. If...
Hello everyone, In this article, I will provide information about listing the Foreign Keys of the selected table in SQL Server. In SQL Server, in some cases, you may want to list the Foreign Keys of the selected table. You can easily do this using the code below. SELECT t.name...
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...
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...
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...
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...
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...
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...