{"id":1883,"date":"2013-08-24T08:28:02","date_gmt":"2013-08-24T08:28:02","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=1883"},"modified":"2017-01-27T12:57:33","modified_gmt":"2017-01-27T03:57:33","slug":"%eb%8f%84%eb%a1%9c%eb%aa%85-%ec%a3%bc%ec%86%8c-ui-%eb%a7%8c%eb%93%a4%ea%b8%b0-%ec%9c%84%ed%95%9c-sql-%eb%ac%b8","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=1883","title":{"rendered":"[GIS] \ub3c4\ub85c\uba85 \uc8fc\uc18c UI \ub9cc\ub4e4\uae30 \uc704\ud55c SQL \ubb38"},"content":{"rendered":"

\uad6d\ub0b4\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uacf5\uac04\ub370\uc774\ud130 \uc911 \ud589\uc548\ubd80\uc758 \uc0c8\uc8fc\uc18c \ub370\uc774\ud130\ub97c \uc774\uc6a9\ud574 \ub3c4\ub85c\uba85 \uc8fc\uc18c UI\ub97c \ub9cc\ub4e4\uae30 \uc704\ud55c SQL\ubb38\uc744 \uc815\ub9ac\ud574 \ubcf4\ub824 \ud569\ub2c8\ub2e4. \ud589\uc815\uad6c\uc5ed\uc740 \uc11c\uc6b8\uc2dc\ub97c \ub300\uc0c1\uc73c\ub85c \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ub3c4\ub85c\uba85 \uc8fc\uc18c \uccb4\uacc4\uac00 \ud2b9\uc815 \uc9c0\uc5ed\uc5d0 \ub300\ud574 \ud2b9\uc774\uc0ac\ud56d\uc774 \uc788\ub294 \uac83\uc740 \uc544\ub2c8\uc9c0\ub9cc.. \uc77c\ub2e8 \uc11c\uc6b8\uc2dc\uc758 \uacbd\uc6b0 \ub3c4\ub85c\uba85 \uc8fc\uc18c\ub294 \uad6c\ub97c \uc120\ud0dd\ud558\uba74 \ud574\ub2f9 \uad6c\uc5d0 \uc18c\uc18d\ub41c \ub3c4\ub85c\uba85\ub4e4\uc774 \uc874\uc7ac\ud569\ub2c8\ub2e4. <\/p>\n

\uc11c\uc6b8\uc2dc \ud558\ub098\uc758 \uad6c\uc5d0 \ub300\ud55c \ub3c4\ub85c\uba85\uc740 \uac1c\uc218\ub294 \uc0c1\ub2f9\ud788 \ub9ce\uc544 \uc120\ud0dd\ub41c \uad6c\uc5d0 \ub300\ud55c \ub3c4\ub85c\uba85\uc744 \ud558\ub098\uc758 \ucef4\ubcf4\ubc15\uc2a4 \ucee8\ud2b8\ub864\uc744 \ud1b5\ud574 \uc9d1\uc5b4 \ub123\uc73c\uba74 \uc0ac\uc6a9\uc790\uac00 \uc120\ud0dd\ud558\uae30 \uc5b4\ub835\uc2b5\ub2c8\ub2e4. \ud574\uc11c \ub2e4\uc74c\uc758 UI\ucc98\ub7fc \uc120\ud0dd\ub41c \uad6c\uc5d0 \ub300\ud55c \ub3c4\ub85c\uba85\uc744 \u3131,\u3134,\u3137 \uacfc \uac19\uc740 \uccab\uc790\uc5d0 \ub300\ud55c \uc790\uc74c\uc73c\ub85c \ubd84\ub958\ud558\ub294 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n

\"\uc0ac\uc6a9\uc790
\uc704\uc758 \uadf8\ub9bc\uc5d0\uc11c A Part\uc5d0\ub294 \u3131,\u3134,\u3137\uacfc \uac19\uc740 \ub3c4\ub85c\uba85\uc5d0 \ub300\ud55c \uccab\uc790\uc758 \uc790\uc74c\uc758 \ub9ac\uc2a4\ud2b8\uc774\uace0 B Part\ub294 \uc120\ud0dd \uc790\uc74c\uc5d0 \ub300\ud55c \ub3c4\ub85c\uba85\uc758 \ub9ac\uc2a4\ud2b8\uc785\ub2c8\ub2e4. \ud589\uc548\ubd80\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ub3c4\ub85c\uba85 DB\ub294 tl_sprd_manage\uc785\ub2c8\ub2e4. \uba3c\uc800 A Part\ub97c \uad6c\uc131\ud558\uae30 \uc704\ud55c SQL(MSSQL Server \uae30\uc900) \ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

select distinct GetConsonant(SUBSTRING(RN,1,1)) \r\nfrom tl_sprd_manage \r\nwhere SIG_CD = \u2018{SIG_CD} ' \r\ngroup by RN<\/pre>\n
{SIG_CD}\ub294 \uc11c\uc6b8\uc2dc\uc758 \uad6c\uc5d0 \ub300\ud55c 5\uc790\ub9ac\uc758 \ud589\uc815\ucf54\ub4dc \uac12\uc785\ub2c8\ub2e4. \ub610\ud55c \uc704\uc758 SQL \ubb38\uc5d0\ub294 GetConsonat \ud568\uc218\uac00 \uc0ac\uc6a9\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \ud568\uc218\uc5d0 \ub300\ud55c \uc815\uc758\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n
create FUNCTION GetConsonant\r\n(\r\n  @STR AS NVARCHAR(100)\r\n)\r\nRETURNS NVARCHAR(100)\r\nAS\r\nBEGIN\r\n  DECLARE @STR_N NVARCHAR(100)\r\n  DECLARE @STR_S NVARCHAR(100)\r\n  WHILE (LEN(@STR) > 0)\r\n  BEGIN\r\n    SET @STR_N = SUBSTRING(@STR, 1, 1)\r\n    SET @STR = SUBSTRING(@STR, 2, LEN(@STR))\r\n    SET @STR_S = ISNULL(@STR_S, '') + \r\n      (CASE WHEN @STR_N BETWEEN '\uac00' AND '\uae4b' THEN '\u3131'\r\n          WHEN @STR_N BETWEEN '\ub098' AND '\ub2e3' THEN '\u3134'\r\n          WHEN @STR_N BETWEEN '\ub2e4' AND '\ub52f' THEN '\u3137'\r\n          WHEN @STR_N BETWEEN '\ub77c' AND '\ub9c7' THEN '\u3139'\r\n          WHEN @STR_N BETWEEN '\ub9c8' AND '\ubc13' THEN '\u3141'\r\n          WHEN @STR_N BETWEEN '\ubc14' AND '\ube5f' THEN '\u3142'\r\n          WHEN @STR_N BETWEEN '\uc0ac' AND '\uc2f7' THEN '\u3145'\r\n          WHEN @STR_N BETWEEN '\uc544' AND '\uc78f' THEN '\u3147'\r\n          WHEN @STR_N BETWEEN '\uc790' AND '\uc9db' THEN '\u3148'\r\n          WHEN @STR_N BETWEEN '\ucc28' AND '\uce73' THEN '\u314a'\r\n          WHEN @STR_N BETWEEN '\uce74' AND '\ud0bf' THEN '\u314b'\r\n          WHEN @STR_N BETWEEN '\ud0c0' AND '\ud30b' THEN '\u314c'\r\n          WHEN @STR_N BETWEEN '\ud30c' AND '\ud557' THEN '\u314d'\r\n          WHEN @STR_N BETWEEN '\ud558' AND '\ud7a3' THEN '\u314e'\r\n          ELSE @STR_N END)\r\n       END\r\n  RETURN @STR_S\r\nEND<\/pre>\n
\uc774\uc81c B Part\uc5d0 \ub300\ud55c SQL\ubb38\uc744 \uc0b4\ud3b4\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n
select RN, RN_CD from tl_sprd_manage where SIG_CD = \u2018{SIG_CD}' \r\nand GetConsonant(SUBSTRING(RN,1,1))='\u3131' \r\ngroup by RN, RN_CD order by RN<\/pre>\n
\uc704\uc758 SQL\uc740 A Part\uc5d0\uc11c ‘\u3131’\uc744 \uc120\ud0dd\ud588\uc744\ub54c ‘\u3131’\uc73c\ub85c \uc2dc\uc791\ud558\ub294 \ub3c4\ub85c\uba85\uc758 \ub9ac\uc2a4\ud2b8\ub97c \ubf51\uc544\ub0c5\ub2c8\ub2e4. \ucc38\uace0\ub85c RN\uc740 \ub3c4\ub85c\uba85\uc774\uba70 RN_CD\ub294 \ub3c4\ub85c\uba85\uc5d0 \ub300\ud55c \ucf54\ub4dc\uac12\uc785\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\uad6d\ub0b4\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uacf5\uac04\ub370\uc774\ud130 \uc911 \ud589\uc548\ubd80\uc758 \uc0c8\uc8fc\uc18c \ub370\uc774\ud130\ub97c \uc774\uc6a9\ud574 \ub3c4\ub85c\uba85 \uc8fc\uc18c UI\ub97c \ub9cc\ub4e4\uae30 \uc704\ud55c SQL\ubb38\uc744 \uc815\ub9ac\ud574 \ubcf4\ub824 \ud569\ub2c8\ub2e4. \ud589\uc815\uad6c\uc5ed\uc740 \uc11c\uc6b8\uc2dc\ub97c \ub300\uc0c1\uc73c\ub85c \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ub3c4\ub85c\uba85 \uc8fc\uc18c \uccb4\uacc4\uac00 \ud2b9\uc815 \uc9c0\uc5ed\uc5d0 \ub300\ud574 \ud2b9\uc774\uc0ac\ud56d\uc774 \uc788\ub294 \uac83\uc740 \uc544\ub2c8\uc9c0\ub9cc.. \uc77c\ub2e8 \uc11c\uc6b8\uc2dc\uc758 \uacbd\uc6b0 \ub3c4\ub85c\uba85 \uc8fc\uc18c\ub294 \uad6c\ub97c \uc120\ud0dd\ud558\uba74 \ud574\ub2f9 \uad6c\uc5d0 \uc18c\uc18d\ub41c \ub3c4\ub85c\uba85\ub4e4\uc774 \uc874\uc7ac\ud569\ub2c8\ub2e4. \uc11c\uc6b8\uc2dc \ud558\ub098\uc758 \uad6c\uc5d0 \ub300\ud55c \ub3c4\ub85c\uba85\uc740 \uac1c\uc218\ub294 \uc0c1\ub2f9\ud788 \ub9ce\uc544 \uc120\ud0dd\ub41c \uad6c\uc5d0 \ub300\ud55c \ub3c4\ub85c\uba85\uc744 … <\/p>\n
\ub354 \ubcf4\uae30 “[GIS] \ub3c4\ub85c\uba85 \uc8fc\uc18c UI \ub9cc\ub4e4\uae30 \uc704\ud55c SQL \ubb38”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[5,98,99],"class_list":["post-1883","post","type-post","status-publish","format-standard","hentry","category-gis-working-history","tag-gis","tag-98","tag-99"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1883"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1883\/revisions"}],"predecessor-version":[{"id":2958,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1883\/revisions\/2958"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1883"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}