1、比较四个值中的大小,取最大值
ALTER FUNCTION [dbo].[F_GET_MAX_RADIO]
( @var1 AS float =0 ,
@var2 AS float =0 ,
@var3 AS float =0 ,
@var4 AS float =0
)
RETURNS float
AS
BEGIN
declare @maxVar float;
if ABS(@var1) > ABS(@var2)
set @maxVar = @var1;
else
set @maxVar = @var2;
if ABS(@maxVar) > ABS(@var3)
set @maxVar = @maxVar;
else
set @maxVar = @var3;
if ABS(@maxVar) >ABS(@var4)
set @maxVar = @maxVar;
else
set @maxVar = @var4;
return @maxVar
END