1. Function For Maximum Number:
CREATE FUNCTION fn_MaxInt
(
@firstNumber int,
@secondNumber int
)
RETURNS int
AS
BEGIN
DECLARE
@maxNumber int =
CASE
WHEN @firstNumber > @secondNumber THEN @firstNumber
ELSE @secondNumber
END
RETURN @maxNumber
END
2. Implementation Of Function:
Output
CREATE FUNCTION fn_MinInt
(
@firstNumber int,
@secondNumber int
)
RETURNS int
AS
BEGIN
DECLARE
@minNumber int =
CASE
WHEN
@firstNumber < @secondNumber THEN @firstNumber
ELSE
@secondNumber
END
RETURN @minNumber
END
SELECT dbo.fn_MinInt (12,34)AS MINNUMBER
Output
Join the conversation! Your thoughts help the community grow.