- Scalar Valued Functions
Let us direct to acutal instance:
USE [*****]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[aaa_GetExcessiveFobearance_HDM]
(
@LoanNo As varchar(10),
@CapitalizedDebt DECIMAL(14,2),
@PropertyValue DECIMAL(14,2),
@MaximumForbearance DECIMAL(14,2),
@MaximumForgiveness DECIMAL(14,2)
)
RETURNS
BIT
AS
BEGIN
.......
SELECT @ForbearanceLimit = [dbo].GetInvestorForbearanceLimit](@LoanNo,@CapitalizedDebt,@PropertyValue)
.......
RETURN @ExcessiveFBFlag
END
Yes, we need take a look at the “Returns : BIT” which is the type of “Return : @ExcessiveFBFlag”.
This value can be got using below sql:
select dbo.aaa_GetExcessiveFobearance_HDM
(
'0014585897', 35940.99,70000,0,1569.35
) as ExcessiveFBFlag
You can notice the structure of this function that you can know how to use this Scalar Valued Function.
When you need the value of it in some other requirement, you just can use it as a column in the specific sql statement.