摘要:
UPDATE mms_wzmxSET mms_wzmx.jldwbm = (SELECT code FROM sys_code WHERE mms_wzmx.jldwmc=sys_code.text and length(sys_code.code)>4 ) 阅读全文
摘要:
insertintomms_gys(gysbm,gysmc,sybz,ywm)selectlpad(HXYGYS.nextval,6,'0'),gys,'1',f_pinyin(gys)fromgys 阅读全文