{"id":2101,"date":"2016-08-08T12:28:22","date_gmt":"2016-08-08T03:28:22","guid":{"rendered":"http:\/\/ocworld.net\/?p=2101"},"modified":"2024-12-13T15:02:35","modified_gmt":"2024-12-13T06:02:35","slug":"ms-sql-%ed%95%84%eb%93%9c%ea%b0%92-%eb%b6%80%eb%b6%84-%ec%88%98%ec%a0%95-%ec%bf%bc%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/www.ocworld.net\/?p=2101","title":{"rendered":"MS SQL \ud544\ub4dc\uac12 \ubd80\ubd84 \uc218\uc815 \ucffc\ub9ac"},"content":{"rendered":"<p>MS SQL\uc5d0\uc11c \ud544\ub4dc \ubd80\ubd84 \uac12\uc744 \uc218\uc815\ud558\uace0 \uc2f6\uc744 \ub54c \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac\ub2e4.<\/p>\n<p>\ud639\uc2dc replace([\ud544\ub4dc\uba85], &#8216;\uad50\uccb4 \uc804&#8217;, &#8216;\uad50\uccb4 \ud6c4&#8217;)\ub85c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \uc624\ub958\uba54\uc2dc\uc9c0\uac00 \ubcf4\uc778\ub2e4\uba74 \uc544\ub798\ucc98\ub7fc \uc801\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/p>\n<p>UPDATE [\ud14c\uc774\ube14] SET [\ud544\ub4dc\uba85] = replace(convert(varchar(max), [\ud544\ub4dc\uba85]), &#8216;\uad50\uccb4 \uc804&#8217;, &#8216;\uad50\uccb4 \ud6c4&#8217;)<br \/>\nWHERE ~~~<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MS SQL\uc5d0\uc11c \ud544\ub4dc \ubd80\ubd84 \uac12\uc744 \uc218\uc815\ud558\uace0 \uc2f6\uc744 \ub54c \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac\ub2e4. \ud639\uc2dc replace([\ud544\ub4dc\uba85], &#8216;\uad50\uccb4 \uc804&#8217;, &#8216;\uad50\uccb4 \ud6c4&#8217;)\ub85c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \uc624\ub958\uba54\uc2dc\uc9c0\uac00 \ubcf4\uc778\ub2e4\uba74 \uc544\ub798\ucc98\ub7fc \uc801\uc6a9\ud558\uba74 \ub41c\ub2e4. UPDATE [\ud14c\uc774\ube14] SET [\ud544\ub4dc\uba85] = replace(convert(varchar(max), [\ud544\ub4dc\uba85]), &#8216;\uad50\uccb4 \uc804&#8217;, &#8216;\uad50\uccb4 \ud6c4&#8217;) WHERE ~~~<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[176],"class_list":["post-2101","post","type-post","status-publish","format-standard","hentry","category-info","tag-ms-sql"],"_links":{"self":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts\/2101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2101"}],"version-history":[{"count":2,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts\/2101\/revisions"}],"predecessor-version":[{"id":2103,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=\/wp\/v2\/posts\/2101\/revisions\/2103"}],"wp:attachment":[{"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ocworld.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}