Oracle:
CREATE OR REPLACE PROCEDURE maxserialno
(returnNum out number
) AS
--声明语句段
--maxnum number;
BEGIN
--执行语句段
SELECT myid INTO returnNum FROM serialno;
update serialnoset myid= returnNum + 1;
END;
Sqlserver:
ALTER PROCEDURE [dbo].[maxserialno]
@outpara int OUTPUT
AS
select @outpara = myidFROM serialno
update serialno
set myid= @outpara + 1
Sybase:
CREATE PROCEDURE dbo.maxserialno
@outpara int output
/* [ (@param_name datatype [= default] [output] ), ... ] */
WITH RECOMPILE
AS
BEGIN
select @outpara = myidFROM serialno
update serialno
set myid = @outpara + 1
END