XSZD00982 太原市迎泽区爱萍诊所
update spls_ck set dwbh=‘CWI00003358‘ where dwbh=‘DWI00003358‘ and djbh not in (‘XSAYMA00035515‘,‘XSDYMA00008608‘,‘XSAYMA00099536‘,‘XSDYMA00023350‘)
update wlzhk set dwbh=‘CWI00003358‘ where dwbh=‘DWI00003358‘ and djbh not in (‘XSAYMA00035515‘,‘XSDYMA00008608‘,‘XSAYMA00099536‘,‘XSDYMA00023350‘)
update cwk set dwbh=‘CWI00003358‘ where dwbh=‘DWI00003358‘ and djbh not in (‘XSAYMA00035515‘,‘XSDYMA00008608‘,‘XSAYMA00099536‘,‘XSDYMA00023350‘)
update pf_ckhz set dwbh=‘CWI00003358‘ where dwbh=‘DWI00003358‘ and djbh not in (‘XSAYMA00035515‘,‘XSDYMA00008608‘,‘XSAYMA00099536‘,‘XSDYMA00023350‘)
update mxysyf set dwbh=‘CWI00003358‘ where dwbh=‘DWI00003358‘ and djbh not in (‘XSAYMA00035515‘,‘XSDYMA00008608‘,‘XSAYMA00099536‘,‘XSDYMA00023350‘)
update wlzhk set ye=0 where dwbh=‘DWI00003358‘ and djbh =‘XSDYMA00023350‘
update wlzhk set ye=8742.00 where dwbh=‘DWI00003358‘ and djbh =‘XSAYMA00099536‘
原文:http://bks2015.blog.51cto.com/9847303/1890835