sqlserver:
update a set a.fenqu=b.fenqu from j2_unitcode a inner join j2_unitcode_bak b on a.code=b.code and len(b.code)=6 and len(isnull(b.fenqu,''))>0
janehlp 2017-07-11 16:10 原文
sqlserver:
update a set a.fenqu=b.fenqu from j2_unitcode a inner join j2_unitcode_bak b on a.code=b.code and len(b.code)=6 and len(isnull(b.fenqu,''))>0