논문준비 - 편집 역사

Hiblue: /* sql */

2018-07-24T09:20:26Z

‎sql

2018-07-09T07:40:24Z

‎Related Ontology

2018-04-30T00:50:06Z

‎OWL

2018-04-26T03:23:00Z

2018-04-20T06:50:58Z

새 문서: ===OWL-Time===

새 문서

===[[OWL-Time]]===

← 이전 판		2018년 7월 24일 (화) 09:20 판
31번째 줄:		31번째 줄:
	select distinct 서기, 단기, 간지 into k_year from 번역연호		select distinct 서기, 단기, 간지 into k_year from 번역연호
	select distinct 서기, 나라_한글, 휘이름 into k_yearLink 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

← 이전 판		2018년 7월 9일 (월) 07:40 판
2번째 줄:		2번째 줄:
	===[[OWL-Time]]===		===[[OWL-Time]]===
	===[[OWL-ref]]===		===[[OWL-ref]]===
		+	==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 번역연호

@@ 1번째 줄: / 1번째 줄: @@
 ==Related Ontology==
 ===[[OWL-Time]]===
-===[[OWL]]===
+===[[OWL-ref]]===