--针对商品货号-商品为字母数字和下划线组成--
--95 _
--65-90 A-Z
--97-122 a-z
--48-57 0-9
create table #tab_item_no(t_id decimal(18,0) identity(1,1),item_no varchar(40))
create table #tab_item_no_rtn(t_id decimal(18,0) identity(1,1),item_no varchar(40))
declare @ll_count decimal(18,0),@ll_len int,@ll_ascii int,@ls_item_no varchar(40)
insert into #tab_item_no
select item_no from t_bd_item_info with(nolock)
set @ll_count = 0
select @ll_count = count(*) from #tab_item_no
while @ll_count > 0
begin
set @ls_item_no = ''
select @ls_item_no = item_no from #tab_item_no where t_id = @ll_count
--95 _
--65-90 A-Z
--97-122 a-z
--48-57 0-9
create table #tab_item_no(t_id decimal(18,0) identity(1,1),item_no varchar(40))
create table #tab_item_no_rtn(t_id decimal(18,0) identity(1,1),item_no varchar(40))
declare @ll_count decimal(18,0),@ll_len int,@ll_ascii int,@ls_item_no varchar(40)
insert into #tab_item_no
select item_no from t_bd_item_info with(nolock)
set @ll_count = 0
select @ll_count = count(*) from #tab_item_no
while @ll_count > 0
begin
set @ls_item_no = ''
select @ls_item_no = item_no from #tab_item_no where t_id = @ll_count