Category: Functions

What are the Differences Between Function and Procedure in SQL Server?

Hello everyone, In this article, I will give information about what are the Differences Between Function and Procedure in SQL Server. This question especially comes to mind of curious friends who are just learning SQL Server. This question may come up in job interviews. It is useful to know briefly,...

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!