在sql中执行下下面语句
declare @i int,@item_barcode varchar(100),@item_no varchar(10),@zj1 int,@zj2 int ,@sum int
set @i=1
declare mycursor cursor for select item_no from t_item_info
open mycursor
fetch mycursor into @item_no
while @@fetch_status=0
begin
select @item_barcode=right(('0000000000000000'+convert(varchar(10),@i)),12)
select @zj1=convert(int,substring(@item_barcode,12,1))+convert(int,substring(@item_barcode,10,1))+convert(int,substring(@item_barcode,8,1))+convert(int,substring(@item_barcode,6,1))+convert(int,substring(@item_barcode,4,1))+convert(int,substring(@item_barcode,2,1))
select @zj2=convert(int,substring(@item_barcode,11,1))+convert(int,substring(@item_barcode,9,1))+convert(int,substring(@item_barcode,7,1))+convert(int,substring(@item_barcode,5,1))+convert(int,substring(@item_barcode,3,1))+convert(int,substring(@item_barcode,1,1))
select @zj1=@zj1*3+@zj2
declare @j int
set @j=1
while @j*10<@zj1
begin
select @j=@j+1
end
select @sum=@j*10-@zj1
update t_item_info set item_barcode=@item_barcode+convert(varchar(10),@sum) where item_no=@item_no
select @i=@i+1
select @zj1=''
select @zj2=''

fetch mycursor into @item_no
end
close mycursor
deallocate mycursor