Question

帮忙解决下oracle存储过程转换位SqlServer存储过程，谢谢！

CREATE procedure getOrderNO
(var_No out varchar2,
tabName in varchar2,
fieldName in varchar2,
sdate in varchar2,
prefix in varchar2)
is
maxcount int;
dynamcisql varchar2(200);

begin
dynamcisql:='select to_number(substr(max('||fieldName||'),11)+1) from '||tabName||' where substr('||fieldName||',3,8)='||sdate||' and '||fieldName||' like '||chr(39)||prefix||'%'||chr(39);

execute immediate dynamcisql into maxcount;

if maxcount is null
then maxcount:=1;
end if;

var_No:=(prefix||sdate||lpad(maxcount,4,'0'));
dbms_output.put_line(var_No);

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