| 12345678910111213141516 |
- 增量查询SQL:
- select e.enumdiccode, e.enumitemname, e.enumdicname
- from ENUMDICITEM e
- left join ENUMDICITEMex ex on e.enumdiccode = ex.enumdiccode and e.enumitemname = ex.enumitemname
- where ex.enumdiccode is null
- order by e.enumdiccode, e.enumitemname;
- select e.errorid, e.errorcode, e.description descriptionzh_tw,
- ex.descriptionzh_cn, ex.descriptionen , ex.descriptionth, ex.descriptionvi
- from errorcode e
- left join errorcodeex ex on e.errorid = ex.errorid
- where ex.errorid is null
- order by e.errorid;
|