deng.yinping
05c0a090c5
更新文档
|
2 주 전 | |
|---|---|---|
| .. | ||
| enumdic | 2 주 전 | |
| errorcode | 2 주 전 | |
| 09.dict_init_ex.sql | 2 주 전 | |
| 15.errorcode_ex.sql | 2 주 전 | |
| enumdicitemex.xlsx | 8 달 전 | |
| errorcodeex.xlsx | 8 달 전 | |
| readme.txt | 2 주 전 | |
readme.txt
增量查询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;
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;