Category: Functions

SQL Server Functions articles and Function code examples

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

Simple Interest Calculation Function in SQL Server

Hello everyone, In this article, I will try to give information about the simple interest calculation function in SQL Server. In SQL Server, in some cases, you may want to calculate interest simply. You can easily do this using the function below. CREATE FUNCTION dbo.SimpleInterestFunction ( @Principal DECIMAL(18, 2) =...

Function Parses JSON in SQL Server

Hello everyone, In this article, I will try to give information about the function that parses JSON in SQL Server. In SQL Server, in some cases, you may want to parse the JSON data you have. You can easily do this using the function below. CREATE FUNCTION [dbo].[parseJSON] ( @JSON...

Don`t copy text!