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:
SELECT dbo.fn_MaxInt (12,34)AS MAXNUMBER
Output
3. Function For Minimum Number:
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
4. Implementation Of Function:
SELECT dbo.fn_MinInt (12,34)AS MINNUMBER
Output