Category: Functions

SQL Server Functions articles and Function code examples

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

Function Controlling Weekdays in SQL Server

Hello everyone, In this article, I will give information about the function that controls weekdays in SQL Server. In SQL Server we may want to check the weekdays in some cases. You can easily do this with the help of the function below. CREATE FUNCTION CheckYourWeekdays ( @Date DATE )...

Don`t copy text!