Question

oracle存储过程转换成sqlserver存储过程

麻烦高手将下面的oracle存储过程转换成sqlserver存储过程：
create or replace procedure p
(v_a in number, v_b number, v_ret out number, v_temp in out number )
is
begin
if(v_a>v_b) then
v_ret := v_a;
else
v_ret := v_b;
end if;
v_temp := v_temp + 1;
end;

Answer 1

CREATE PROCEDURE p
@a int=0, @b int=0, @ret int=0 output,@temp int=0 output
AS
BEGIN
if @a>@b
begin
set @ret = @a
end
else
begin
set @ret = @b
end
set @temp = @temp + 1
END
GO