create function SXTEST(@type int,@first float,@second float)
returns float
as
begin
declare @result float
if(@type=1)--"+"
begin
set @result=@first+@second
end
if(@type=2)--"-"
begin
set @result=@first-@second
end
return @result
end
以上代码不用if,用case when 如何实现??
returns float
as
begin
declare @result float
if(@type=1)--"+"
begin
set @result=@first+@second
end
if(@type=2)--"-"
begin
set @result=@first-@second
end
return @result
end
以上代码不用if,用case when 如何实现??
returns float
as
begin
declare @result float
select @result = case @type when 1 then @first+@second when 2 then @first - @second end
end??
create function SXTEST(@type int,@first float,@second float)
returns float
as
begin
declare @result float
SELECT @result= CASE WHEN @type=1 THEN @first+@second
WHEN @type=0 THEN @first-@second
ELSE 0 END
return @result
end