{"id":1416,"date":"2004-06-02T14:28:21","date_gmt":"2004-06-02T14:28:21","guid":{"rendered":"http:\/\/bluesoul.pe.kr\/wp\/?p=1416"},"modified":"2004-06-02T14:28:21","modified_gmt":"2004-06-02T14:28:21","slug":"%eb%b6%84%ec%82%b0%ed%8a%b8%eb%9e%9c%ec%a0%9d%ec%85%98-%ec%b2%98%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/bluesoul.pe.kr\/wp\/?p=1416","title":{"rendered":"\ubd84\uc0b0\ud2b8\ub79c\uc81d\uc158 \ucc98\ub9ac"},"content":{"rendered":"<p> \ub9c1\ud06c\ub4dc \uc11c\ubc84\ub4f1\uc744 \uc774\uc6a9\ud558\uc5ec \ub9ac\ubaa8\ud2b8\uc11c\ubc84\uc758 \ub370\uc774\ud130\ub4e4\uc744 \ucc98\ub9ac\ud558\ub2e4 \ubcf4\uba74..<br \/>\n\ud2b8\ub79c\uc81d\uc158 \ucc98\ub9ac\ub97c \ud560 \ud544\uc694\uac00 \uc788\ub294\ub370 \uc11c\ubc84\uac00 \ud2c0\ub9ac\uba74 \ub09c\uac10\ud558\ub2e4.<br \/>\nms sql\uc740 \ubd84\uc0b0\ud2b8\ub79c\uc81d\uc158 \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud558\ub294\ub370..<\/p>\n<p>\ubb38\ubc95 \uc790\uccb4\ub294 \uac04\ub2e8\ud558\ub2e4.<\/p>\n<p>\uc77c\ub2e8 \ub85c\uceec\uacfc \ub9ac\ubaa8\ud2b8 \uc11c\ubc84\uc758 dts\uc11c\ubc84\uac00 \uc2a4\ud0c0\ud2b8 \uc0c1\ud0dc\uc5ec\uc57c \ud558\uace0.<br \/>\n\ub450\uc11c\ubc84\uac00 \ub9c1\ud06c\ub4dc \uc11c\ubc84\ub85c \uc5f0\uacb0\ub418\uc5b4 \uc788\ub2e4\uba74 \uc544\ub798\uc640 \uac19\uc774 \ud558\uba74 \ub41c\ub2e4.<\/p>\n<p>set xact_abort on &#8212; \ub7f0\ud0c0\uc784\uc5d0\ub7ec\uc2dc \uc790\ub3d9\uc801\uc73c\ub85c \ub864\ubc31\ud574\uc900\ub2e4.<br \/>\nbegin distributed tran<br \/>\n      delete sales<br \/>\n      insert sales<br \/>\n            exec hantoma_Pubs.pubs.dbo.pSales &#8212; \ub9ac\ubaa8\ud2b8 \uc11c\ubc84\uc758 \ud504\ub85c\uc2dc\uc800\ub97c \uc2e4\ud589\uc2dc\ud0a8\ub2e4.<br \/>\ncommit tran <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub9c1\ud06c\ub4dc \uc11c\ubc84\ub4f1\uc744 \uc774\uc6a9\ud558\uc5ec \ub9ac\ubaa8\ud2b8\uc11c\ubc84\uc758 \ub370\uc774\ud130\ub4e4\uc744 \ucc98\ub9ac\ud558\ub2e4 \ubcf4\uba74.. \ud2b8\ub79c\uc81d\uc158 \ucc98\ub9ac\ub97c \ud560 \ud544\uc694\uac00 \uc788\ub294\ub370 \uc11c\ubc84\uac00 \ud2c0\ub9ac\uba74 \ub09c\uac10\ud558\ub2e4. ms sql\uc740 \ubd84\uc0b0\ud2b8\ub79c\uc81d\uc158 \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud558\ub294\ub370.. \ubb38\ubc95 \uc790\uccb4\ub294 \uac04\ub2e8\ud558\ub2e4. \uc77c\ub2e8 \ub85c\uceec\uacfc \ub9ac\ubaa8\ud2b8 \uc11c\ubc84\uc758 dts\uc11c\ubc84\uac00 \uc2a4\ud0c0\ud2b8 \uc0c1\ud0dc\uc5ec\uc57c \ud558\uace0. \ub450\uc11c\ubc84\uac00 \ub9c1\ud06c\ub4dc \uc11c\ubc84\ub85c \uc5f0\uacb0\ub418\uc5b4 \uc788\ub2e4\uba74 \uc544\ub798\uc640 \uac19\uc774 \ud558\uba74 \ub41c\ub2e4. set xact_abort on &#8212; \ub7f0\ud0c0\uc784\uc5d0\ub7ec\uc2dc \uc790\ub3d9\uc801\uc73c\ub85c \ub864\ubc31\ud574\uc900\ub2e4. begin distributed tran delete sales insert sales exec &hellip; <a href=\"https:\/\/bluesoul.pe.kr\/wp\/?p=1416\" class=\"more-link\">\uacc4\uc18d \uc77d\uae30<span class=\"screen-reader-text\"> &#8220;\ubd84\uc0b0\ud2b8\ub79c\uc81d\uc158 \ucc98\ub9ac&#8221;<\/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":[3],"tags":[],"class_list":["post-1416","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1416"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1416\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}