【数据库SQL】自动生成编号功能

--功能1：自动生成8位数货号，放在备注字段里memo
use issyytv3 
go
declare @id int
declare @no varchar(20)
declare @item_no varchar(20)
select @id=0
declare cur_1 cursor for
select item_no from t_bd_item_info
open cur_1 
fetch cur_1 into @item_no
while @@fetch_status = 0
begin
select @id = @id +1
        select @no = right('00000000' + convert(varchar(10),@id),8)
update t_bd_item_info set memo=@no where item_no=@item_no
fetch cur_1 into @item_no
end
close cur_1
deallocate cur_1
 


--select memo,* from t_bd_item_info order by memo


--功能2：根据当前类别编号获取2位数+6位自动生成，放在备注字段里memo
declare @subno_len int