Scalar Value Function in SQL Server

In SQL Server, a scalar function is a user-defined function that, depending on the input parameters, outputs a single value. Like a formula, it is used to carry out operations with the results.

Create the Function

CREATE FUNCTION dbo.AddTwoNumbers (@Num1 INT, @Num2 INT)
RETURNS INT
AS
BEGIN
    RETURN @Num1 + @Num2;
END;

Use the Function

SELECT dbo.AddTwoNumbers(10, 20) AS SumResult;

output

SumResult  
30