Category: Functions

SQL Server Functions articles and Function code examples

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

Function to Clear Special Characters in SQL Server

Hello everyone, In this article, I will try to give information about the function that clears special characters in SQL Server. In SQL Server you may want to clear special characters in some cases. You can easily do this using the function below. CREATE FUNCTION fn_Ozel_Karakterleri_Temizle (@Temp VARCHAR(2000)) RETURNS VARCHAR(2000)...

Leap Year Checking Function in SQL Server

Hello everybody, In this article, I will try to give information about the leap year control function in SQL Server. In SQL Server, in some cases, you may want to check for leap years. You can easily do this using the function below. CREATE FUNCTION dbo.IsLeapYear ( @year INT )...

Don`t copy text!