Question

利用SQL Server的存储过程找出三个数中的最大值

用T-SQL语言编写，从三个数中找出最大值

Answer 1

create proc getMax @a int ,@b int ,@c int
as
begin
declare @d int
if(@a>=@b)
select @d=@a
else
select @d=@b
if(@d<@c)
select @d=@c
print @d
return @d
end

Answer 2

CREATE proc MaxNum @p1 float ,@p2 float ,@p3 float
as

select max(A)
from(select @p1 as A union select @p2 union select @p3 )a
GO