关于sql中case判断的使用解决思路

关于sql中case判断的使用

SQL code

create function SXTEST(@type int,@first float,@second float)returns floatasbegindeclare @result floatif(@type=1)--"+"begin    set @result=@first+@secondendif(@type=2)--"-"begin    set @result=@first-@secondendreturn @resultend

SQL code

create function SXTEST(@type int,@first float,@second float)returns floatasbegindeclare @result floatselect @result = case @type when 1 then @first+@second when 2 then @first - @second endend
[解决办法]
SQL code
create function SXTEST(@type int,@first float,@second float)returns floatasbegindeclare @result floatSELECT @result= CASE WHEN @type=1 THEN @first+@second                      WHEN @type=0 THEN @first-@second                     ELSE 0 ENDreturn @resultend