sql server 函数

多条件判断，if...else if...或者用case

if...else if...

if (条件)
begin

end
else if (条件)
begin

end
else
begin

end

ALTER FUNCTION [dbo].[score]
( @毛利润金额 AS float =0 ,
  @目标值 AS float =1 ,
  @考核分值 AS numeric =0 
)
RETURNS FLOAT
AS
BEGIN
	-- routine body goes here, e.g.
	-- SELECT 'Navicat for SQL Server'
	DECLARE @考核得分 FLOAT
	IF(@目标值=0)
	BEGIN
	SET  @考核得分=@考核分值
	END
	ELSE IF((@毛利润金额/@目标值)>1.2) 
	BEGIN
	SET  @考核得分=(1.2*@考核分值)
	END
	ELSE  
	BEGIN
	SET @考核得分=@毛利润金额/@目标值*@考核分值
	END
	RETURN (ROUND(@考核得分, 2))
END