Category: SQL Server

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

Parse URL in SQL Server

Hello everyone, In this article, I will give information about URL parsing in SQL Server. In SQL Server you may want to parse the URL in some cases. Let me explain what I mean. Have a URL address like the one below. https://www.example.com/?utm_source=google&utm_medium=blabla&utm_campaign=gameuser&utm_term=winwin&utm_content=takego We will parse this URL address as...

Don`t copy text!