--修改商品档案
UPDATE t_bd_item_info  set item_no  = SUBSTRING(item_no,3,7) where num3<>'0' and LEN(item_no)=7

--机构
UPDATE t_pc_branch_price  set item_no  = SUBSTRING(item_no,3,7) where item_no in 
(select item_no from t_bd_item_info where num3<>'0' and LEN(item_no)=7)

--供货关系
--机构
UPDATE t_bd_supcust_item  set item_no  = SUBSTRING(item_no,3,7) where item_no in 
(select item_no from t_bd_item_info where num3<>'0' and LEN(item_no)=7)