SQLSERVER自增字段和Oracle创建自增字段-ORACLESEQUENCE方法的对比-并且用存储过程实现参数输出

CREATE TABLE [dbo].[Accounts_Permissions](
    [PermissionID] [int] IDENTITY(1,1) NOT NULL, --（自增长1 从1开始）
    [Description] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL,
    [CategoryID] [int] NULL
) ON [PRIMARY]

CREATE PROCEDURE [dbo].[sp_Accounts_CreatePermission]
@CategoryID int,
@Description varchar(50)
AS
    INSERT INTO Accounts_Permissions(CategoryID,Description) VALUES(@CategoryID,@Description)
    RETURN @@IDENTITY

create or replace procedure sp_Acc_CreatePermission(CategoryID  number,
                                                    Description varchar2,
                                                    outid       out number) is
  id number;
begin
  INSERT INTO Accounts_Permissions
    (PERMISSIONID, CategoryID, Description)
  VALUES
    (Seq_Accounts_Permissions.Nextval, CategoryID, Description);
  commit;
  SELECT Seq_Accounts_Permissions.currval into id FROM DUAL; ---返回当前序列的ID号
  dbms_output.put_line(id);
  outid := id;
end;

create or replace function F_ACC_CREATEPERMISSION(CategoryID  in NUMBER,
                                                  Description in VARCHAR2)
  return number is
  Result number;
begin
  INSERT INTO Accounts_Permissions
    (PERMISSIONID, CategoryID, Description)
  VALUES
    (Seq_Accounts_Permissions.Nextval, CategoryID, Description);
  COMMIT;
  SELECT Seq_Accounts_Permissions.currval into Result FROM DUAL;
  return(Result);
end F_ACC_CREATEPERMISSION;