Category: Functions

SQL Server Functions articles and Function code examples

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

Writing a WordWrap Function in SQL Server

Hello everyone, In this article, I will try to give information about writing a WordWrap function in SQL Server. In SQL Server you may need a function like WordWrap in some cases. WordWrap cuts a text to a certain length and displays the remainder on a new line. This is...

Function to Check Mail in SQL Server

Hello everyone, In this article, I will try to give information about the function that checks mail in SQL Server. In some cases, you may want to check the e-mail address you have in SQL Server. You can easily do this using the function below. CREATE FUNCTION fn_eMailKontrol ( @EmailAddr...

Equivalent of Oracle LAST_DAY Function in SQL Server

Hello everyone, In this article, I will give information about the equivalent of the Oracle LAST_DAY() function in SQL Server. In SQL Server, in some cases, we may want to see and use functions that are in other databases. What is the LAST_DAY() function? The LAST_DAY() function returns the date...

Writing Oracle NEXT_DAY Function in SQL Server

Hello everyone, In this article, I will give information about writing the Oracle NEXT_DAY function in SQL Server. In SQL Server, in some cases, we may want to see and use functions that exist in other databases. What is the NEXT_DAY function? The NEXT_DAY function has 2 parameters. The first...

Don`t copy text!