I found the solution myself.

--Autogeneration Procedure

create table RefVal_SID

(

SID int not null,

constraint pk_refval_sid primary key clustered (SID asc)

)

create procedure AutogenerateID

@startchar char(1),

@result varchar(8) output

as

begin

set nocount on;

declare @CurrentSID int

declare @CurrentYear Varchar(4)

declare @UniqueID...

Please help me

Please, I'm a beginner.

After reading Larry Sumuri tutorial on Seral ID Auto generation, I created a procedure.

create table RefVal_SID

(

SID int not null,

constraint pk_refval_sid primary key clustered (SID asc)

)

create procedure AutogenerateID...