更新商锐9.7称重商品简称
use hbposev9
go
update t_bd_item_info set item_subname=left(item_name,10) WHERE (item_subname IS NULL OR item_subname='') AND num3='1'