在保存业务单据时，出现“主键、单号、编码

A、select * from credence where getstrlength(credid)=10，select * from creditem where getstrlength(credid)=10，通过此查询记录，判断凭证主表及从表是否存在10位的编码存在，update credence set credid=substring(credid,1,6)|| 01||substring(credid,7,10) where getstrlength(credid)=10，update