EXCEL 批量生成SQL
1、批量生成更新语句
="update applyloan_zx set fangkuanmoney="&A2&",fangkuantime='"&B2&"',LendingWay='"&C2&"',LendingID="&D2&" where applycode='"&E2&"'"
求知若饥,虚心若愚
I hear and I forget. I see and I remember. I do and I understand
I hear and I forget. I see and I remember. I do and I understand
1、批量生成更新语句
="update applyloan_zx set fangkuanmoney="&A2&",fangkuantime='"&B2&"',LendingWay='"&C2&"',LendingID="&D2&" where applycode='"&E2&"'"
浙公网安备 33010602011771号