The linear_min Scalar Function : Utility function « Procedure Function « SQL Server / T-SQL Tutorial

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

4> CREATE FUNCTION dbo.linear_min(
5>   @arg1 AS int,
6>   @arg2 AS int
7> )
8> RETURNS int
9> AS
10> BEGIN
11>   RETURN CASE
12>            WHEN @arg1 <= @arg2 THEN @arg1
13>            WHEN @arg2 <  @arg1 THEN @arg2
14>            ELSE NULL
15>          END
16> END
17> GO
1> GRANT EXECUTE ON dbo.linear_min TO public
2> GO
1>
2> drop function dbo.linear_min
3> GO