linear_max() Scalar Function : Utility function « Procedure Function « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Procedure Function
3. Utility function

6>  CREATE FUNCTION dbo.linear_max
7>  (
8>    @arg1 AS int,
9>    @arg2 AS int
10>  )
11>  RETURNS int
12>  AS
13>  BEGIN
14>    RETURN CASE
15>             WHEN @arg1 >= @arg2 THEN @arg1
16>             WHEN @arg2 >  @arg1 THEN @arg2
17>             ELSE NULL
18>           END
19>  END
20>  GO
1>
2> SELECT
3>   dbo.linear_max(1, 2)
4>
5>  drop function dbo.linear_max
6>  GO

-----------
          2

(1 rows affected)
1>
2>