3) Write a SQL Function that get the high number from two inputs (a and b); the result should be 1 ifa b else 0

Question

Write a SQL Function that get the high number from two inputs (a and b); the result should be 1 ifa > b else 0

Alexander R. · Accepted Answer

Hi Musa,

CREATE FUNCTION dbo.IsGreater (@input1 int, @input2 int)

RETURNS int

WITH EXECUTE AS CALLER
AS
BEGIN
    RETURN SELECT @input1 > @input2
END

3) Write a SQL Function that get the high number from two inputs (a and b); the result should be 1 ifa > b else 0