논문준비

sql

use hiblue

select top 10 * from dynasty select top 10* from emporor

select e.emperor_id, e.name as emperorName, d.dynasty_id, d.name as dynastyName, e.short_name_eng from dynasty d , emporor e where e.dynasty_id=d.dynasty_id select top 10 * from t_month select top 10 * from t_era select top 10 * from t_era_names

select * from era select era_id, name as eraName, emperor_id, language_id into era from t_era , t_era_names where t_era.id=t_era_names.era_id select e.emperor_id, e.name as emperorName, d.dynasty_id, d.name as dynastyName, era_id, eraname, language_id, e.short_name_eng from dynasty d , emporor e, era where e.dynasty_id=d.dynasty_id and e.emperor_id=era.emperor_id

select distinct e.emperor_id, d.dynasty_id, era_id into yearLink from dynasty d , emporor e, era where e.dynasty_id=d.dynasty_id and e.emperor_id=era.emperor_id

select * from yearLink

use hiblue

select * from t_month select * from 번역연호 select distinct 나라_한글, 나라_한자, 지역 into k_dynasty from 번역연호 select distinct 묘호_한글, 묘호_한자, 시호_한글, 시호_한자, 휘이름 into k_emperor from 번역연호 select distinct 서기, 단기, 간지 into k_year from 번역연호 select distinct 서기, 나라_한글, 휘이름 into k_yearLink from 번역연호

use hiblue

--k_year(번역원) 휘이름 한글한자 분리

select 서기, 나라_한글, left(휘이름, (charindex('(', 휘이름+'(')-1)) as 휘이름_한글, substring (휘이름, (charindex('(', 휘이름)+1), len(휘이름)-charindex('(', 휘이름)-1) as 휘이름_한자 into k_years from k_yearLink

--k_yearLink(번역원) 휘이름 한글한자 분리 select 서기, 나라_한글, left(휘이름, (charindex('(', 휘이름+'(')-1)) as 휘이름_한글, substring (휘이름, (charindex('(', 휘이름)+1), len(휘이름)-charindex('(', 휘이름)-1) as 휘이름_한자 into k_yearLinks from k_yearLink

select * from k_yearLinks

--k_emperor(번역원) 휘이름 한글한자 분리 select 묘호_한글, 묘호_한자, 시호_한글, 시호_한자, left(휘이름, (charindex('(', 휘이름+'(')-1)) as 휘이름_한글, substring (휘이름, (charindex('(', 휘이름)+1), len(휘이름)-charindex('(', 휘이름)-1) as 휘이름_한자 into k_emperors from k_emperor