declare @t table(a int,b int)
insert @t select 00111,00222
insert @t select 00333,00444
--print right('aabbb',3)
declare @maxcode varchar(10)
set @maxcode = '1112220002'
declare @sql nvarchar(50)
--@sql是编号中的max值
set @sql =right(@maxcode,4)
select right(a,3)+right(b,3)+right('0000'+convert(varchar(4),convert(int,right(@sql,4))+1),4) as '编号' from @t

------解决方案--------------------
存储过程调用函数 [dbo].[AutoFamily_Code](数1，数2)