readme.txt 514 B

12345678910111213141516
  1. 增量查询SQL:
  2. select e.enumdiccode, e.enumitemname, e.enumdicname
  3. from ENUMDICITEM e
  4. left join ENUMDICITEMex ex on e.enumdiccode = ex.enumdiccode and e.enumitemname = ex.enumitemname
  5. where ex.enumdiccode is null
  6. order by e.enumdiccode, e.enumitemname;
  7. select e.errorid, e.errorcode, e.description descriptionzh_tw,
  8. ex.descriptionzh_cn, ex.descriptionen , ex.descriptionth, ex.descriptionvi
  9. from errorcode e
  10. left join errorcodeex ex on e.errorid = ex.errorid
  11. where ex.errorid is null
  12. order by e.errorid;