--drop trigger tr_autoadd
go
create trigger tr_autoadd
on autoadd
instead of insert
as
begin
declare @m varchar(5)
declare @n int
--select * from inserted
select @m=b from inserted
if (select count(*) from autoadd)=0
begin
insert into autoadd values('00001',@m)
end
else
begin
select @n=max(cast(a as int))+1 from autoadd
insert into autoadd values(replicate('0',5-len(cast(@n as varchar(5))))+cast(@n as varchar(5)),@m)
end
if @@error<>0
begin
rollback tran
end
end