{"id":1406,"date":"2004-04-23T18:24:02","date_gmt":"2004-04-23T18:24:02","guid":{"rendered":"http:\/\/bluesoul.pe.kr\/wp\/?p=1406"},"modified":"2004-04-23T18:24:02","modified_gmt":"2004-04-23T18:24:02","slug":"mssql-%ec%9e%84%ec%9d%98%ec%9d%98-%eb%b6%84%ec%82%b0%ec%a7%88%ec%9d%98-%eb%a6%ac%eb%aa%a8%ed%8a%b8%ec%84%9c%eb%b2%84%ec%9d%98-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%a5%bc-%ec%9d%bd%ec%96%b4%ec%98%ac","status":"publish","type":"post","link":"https:\/\/bluesoul.pe.kr\/wp\/?p=1406","title":{"rendered":"[MSSQL] \uc784\uc758\uc758 \ubd84\uc0b0\uc9c8\uc758 &#8211; \ub9ac\ubaa8\ud2b8\uc11c\ubc84\uc758 \ub370\uc774\ud130\ub97c \uc77d\uc5b4\uc62c\ub54c"},"content":{"rendered":"<p> \ub9ac\ubaa8\ud2b8 \uc11c\ubc84\uc5d0 \uc788\ub294 \ub370\uc774\ud130\ub97c \uc5bb\uae30 \uc704\ud574 \ubd84\uc0b0\uc9c8\uc758\ub97c \ud558\uae30 \uc704\ud574\uc11c\ub294<br \/>\n\ub9c1\ud06c\ub4dc \uc11c\ubc84\ub97c \uc815\uc758\ud558\uac70\ub098 OPENROWSET \uc774\ub77c\ub294 \ud568\uc218\ub97c \uc0ac\uc6a9\ud574\uc11c \uc784\uc758\uc758 \ubd84\uc0b0\uc9c8\uc758\ub97c \ud574\uc57c \ud55c\ub2e4.<br \/>\nOPENROWSET \uc744 \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud558\ub294\uc9c0 \ubcf4\uc790<br \/>\n\uc544\ub798 \uc608\uc81c\ub294 \ud55c\ud1a0\ub9c8\uc5d0\uc11c \ub9ac\uc2a4\ud2b8 \ud398\uc774\uc9c0\uc5d0 \uc4f0\uc774\ub294 sql\ubb38\uc774\ub2e4.<\/p>\n<p>Select Top (\uc6d0\ud558\ub294\ub808\ucf54\ub4dc\uac2f\uc218) a.*,b.wLevel<br \/>\nFrom (\ud14c\uc774\ube14\uc774\ub984) a<br \/>\nLeft Outer Join<br \/>\nOPENROWSET(&#8216;MSDASQL&#8217;,&#8217;dsn=hantoma;UID=xxx;PWD=xxx&#8217;,&#8217;select memberid,wLevel<br \/>\nfrom hantoma.dbo.writer_Status&#8217;) AS b<br \/>\non a.id=b.memberid<br \/>\nWhere Idx Not In<br \/>\n(Select Top (\uc804\ub2ec\ub41c\ud398\uc774\uc9c0\uc218-1)*\uc6d0\ud558\ub294\ub808\ucf54\ub4dc\uac2f\uc218 idx From \ud14c\uc774\ube14\uc774\ub984 Order By ref desc)<br \/>\nOrder By ref desc<\/p>\n<p>\uc5ec\uae30\uc11c Left Outer Join \uc740 \uc54c\uace0 \uacc4\uc2dc\uaca0\uc9c0\ub9cc<br \/>\na \ud14c\uc774\ube14\uc758 \ud544\ub4dc \ub0b4\uc6a9\uc744 \ubaa8\ub450 \uae01\uc5b4 \uc624\uae30 \uc704\ud574 \uc37c\ub2e4.<br \/>\nMSDASQL \ud504\ub85c\ubc14\uc774\ub354 \uc774\ub984\uc774\ub2e4 \uc624\ub77c\ud074\uc740 MSDAORA<br \/>\nhantoma.dbo.writer_status \ub294 \ub514\ube44.\uc18c\uc720\uc790.\ud14c\uc774\ube14\uc774\ub984<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub9ac\ubaa8\ud2b8 \uc11c\ubc84\uc5d0 \uc788\ub294 \ub370\uc774\ud130\ub97c \uc5bb\uae30 \uc704\ud574 \ubd84\uc0b0\uc9c8\uc758\ub97c \ud558\uae30 \uc704\ud574\uc11c\ub294 \ub9c1\ud06c\ub4dc \uc11c\ubc84\ub97c \uc815\uc758\ud558\uac70\ub098 OPENROWSET \uc774\ub77c\ub294 \ud568\uc218\ub97c \uc0ac\uc6a9\ud574\uc11c \uc784\uc758\uc758 \ubd84\uc0b0\uc9c8\uc758\ub97c \ud574\uc57c \ud55c\ub2e4. OPENROWSET \uc744 \uc5b4\ub5bb\uac8c \uc0ac\uc6a9\ud558\ub294\uc9c0 \ubcf4\uc790 \uc544\ub798 \uc608\uc81c\ub294 \ud55c\ud1a0\ub9c8\uc5d0\uc11c \ub9ac\uc2a4\ud2b8 \ud398\uc774\uc9c0\uc5d0 \uc4f0\uc774\ub294 sql\ubb38\uc774\ub2e4. Select Top (\uc6d0\ud558\ub294\ub808\ucf54\ub4dc\uac2f\uc218) a.*,b.wLevel From (\ud14c\uc774\ube14\uc774\ub984) a Left Outer Join OPENROWSET(&#8216;MSDASQL&#8217;,&#8217;dsn=hantoma;UID=xxx;PWD=xxx&#8217;,&#8217;select memberid,wLevel from hantoma.dbo.writer_Status&#8217;) AS b on a.id=b.memberid Where Idx Not In (Select &hellip; <a href=\"https:\/\/bluesoul.pe.kr\/wp\/?p=1406\" class=\"more-link\">\uacc4\uc18d \uc77d\uae30<span class=\"screen-reader-text\"> &#8220;[MSSQL] \uc784\uc758\uc758 \ubd84\uc0b0\uc9c8\uc758 &#8211; \ub9ac\ubaa8\ud2b8\uc11c\ubc84\uc758 \ub370\uc774\ud130\ub97c \uc77d\uc5b4\uc62c\ub54c&#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-1406","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\/1406","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=1406"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1406\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}