MSSQL Query Blog

Creating a Recursive Menu in SQL Server

Hello everyone. In this article, I will try to give information about creating a Recursive Menu in SQL Server. You can create simple or advanced nested menus in SQL Server. First, let’s create a table called “Menu”. CREATE TABLE Menu ( MenuID INT PRIMARY KEY ,MenuName NVARCHAR(50) ,ParentMenuID INT NULL...

Formatting an IBAN Number in SQL Server

Hello everyone. In this article, I will give information about formatting an IBAN number in SQL Server. In SQL Server, in some cases, you may want to format the IBAN number. You can easily do this using the code below. DECLARE @iban VARCHAR(50) = ‘TR320010009999901234567890’; SELECT CONCAT(SUBSTRING(@iban, 1, 2), ‘...

Converting Hijri Date to Gregorian Date in SQL Server

Hello everyone. In this article, I will give information about converting Hijri date to Gregorian date in SQL Server. In SQL Server, in some cases, you may want to convert the Hijri date to the Gregorian date. You can easily do this using the code below. SELECT CONVERT(DATETIME, value, 131)...

Using CROSS APPLY in SQL Server

Hello everyone, In this article I will share information about using CROSS APPLY in SQL Server In SQL Server, CROSS APPLY is a JOIN operator that allows you to apply data from one table or query to another table or query. CROSS APPLY, like OUTER APPLY, is one of the...

Using OUTER APPLY in SQL Server

Hello everyone, In this article, I will share information about using OUTER APPLY in SQL Server. In SQL Server, OUTER APPLY is a JOIN operator that allows you to apply data from one table or query to another table or query. OUTER APPLY, like CROSS APPLY, is one of the...

Don`t copy text!