update t1 set E = name+case when E is null or E ='' then '' else '-'+ E end , name ='其他生活用电器' ,a =case when len(t1.a )=7 then t1.a else '2' end from T_d t1