怎么创建函数？为啥小弟我这段代码有异常

如何创建函数？为啥我这段代码有错误？

SQL code

create function hello2(@ix int,@iy int)return int isdeclare @temp int;if (@ix > @iy)begin @temp = @ixendelsebegin@temp = @iyendreturn @temp

[解决办法]

探讨

引用:

create function hello2(@ix int,@iy int)
return int
is
declare @temp int;
if (@ix > @iy)
begin
set @temp = @ix
end
else
begin
set @temp = @iy
end
return @temp


还是……

[解决办法]
create function hello2(@ix int,@iy int)
returns int
as
begindeclare @temp int;
if (@ix > @iy)
begin
set @temp = @ix
end
else
begin
set @temp = @iy
end
return @temp
end

查看更多 下一篇