27 lines
509 B
SQL
27 lines
509 B
SQL
CREATE OR ALTER FUNCTION dbo.LEAST_NUMERIC205(
|
|
@a NUMERIC(20,5),
|
|
@b NUMERIC(20,5)
|
|
)
|
|
RETURNS NUMERIC(20,5)
|
|
AS
|
|
BEGIN
|
|
RETURN CASE
|
|
WHEN @a IS NULL THEN @b
|
|
WHEN @b IS NULL THEN @a
|
|
WHEN @a < @b THEN @a ELSE @b
|
|
END
|
|
END
|
|
|
|
CREATE OR ALTER FUNCTION dbo.GREATEST_NUMERIC205(
|
|
@a NUMERIC(20,5),
|
|
@b NUMERIC(20,5)
|
|
)
|
|
RETURNS NUMERIC(20,5)
|
|
AS
|
|
BEGIN
|
|
RETURN CASE
|
|
WHEN @a IS NULL THEN @b
|
|
WHEN @b IS NULL THEN @a
|
|
WHEN @a > @b THEN @a ELSE @b
|
|
END
|
|
END |