{"id":5028,"date":"2022-03-23T15:18:20","date_gmt":"2022-03-23T06:18:20","guid":{"rendered":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=5028"},"modified":"2022-03-24T14:31:10","modified_gmt":"2022-03-24T05:31:10","slug":"mssql-openquery","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=5028","title":{"rendered":"MSSQL OPENQUERY"},"content":{"rendered":"<h1>MSSQL OPENQUERY<\/h1>\n<pre><code class=\"language-sql\">SELECT * FROM OPENQUERY(L_TESTDB, &#039;SELECT * FROM LinkedServerTestTable&#039;);\n\nINSERT OPENQUERY(L_TESTDB, &#039;SELECT NO, NAME FROM LinkedServerTestTable &#039;) VALUES (1, &#039;\ud64d\uae38\ub3d9&#039;);\n\nINSERT INTO OPENQUERY (L_TESTDB, &#039;SELECT AAA, BBB, CCC FROM LinkedServerTestTable&#039;)\nSELECT AAA, BBB, CCC\nFROM tbl_table\nwhere\n    1 = 1\n    and AAA &gt;= &#039;2019-08-01&#039;\n    and AAA &lt; &#039;2019-09-01&#039;;\n\nUPDATE OPENQUERY(L_TESTDB, &#039;SELECT NAME FROM LinkedServerTestTable WHERE NO = 1&#039;) SET NAME = &#039;\uc784\uaebd\uc815&#039;;\n\n-- \ud30c\ub77c\ubbf8\ud130\ub294 \ubb38\uc790\uc5f4 \ud569\uce58\uae30\ub97c \uc774\uc6a9\ud574 \uc804\ub2ec\ud569\ub2c8\ub2e4.\nDECLARE @VAL VARCHAR(10);\nSET @VAL = &#039;20&#039;;\nUPDATE OPENQUERY(L_TESTDB, &#039;SELECT NAME FROM LinkedServerTestTable WHERE NO = &#039; + @VAL + &#039; AND BBB = 2&#039;) SET NAME = &#039;\uc784\uaebd\uc815&#039;;\n\n-- SELECT * FROM \uc744 \ud574\uc57c \ud569\ub2c8\ub2e4.\n-- \uc0ad\uc81c\ud560 \uac74\uc218\uac00 \ub9ce\uc740 \uacbd\uc6b0 \ub9e4\uc6b0 \ub290\ub9ac\ub2e4.\nDELETE OPENQUERY(L_TESTDB, &#039;SELECT * FROM LinkedServerTestTable WHERE NO = 1&#039;);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MSSQL OPENQUERY SELECT * FROM OPENQUERY(L_TESTDB, &#039;SELECT * FROM LinkedServerTestTable&#039;); INSERT OPENQUERY(L_TESTDB, &#039;SELECT NO, NAME FROM LinkedServerTestTable &#039;) VALUES (1, &#039;\ud64d\uae38\ub3d9&#039;); INSERT INTO OPENQUERY (L_TESTDB, &#039;SELECT AAA, BBB, CCC FROM LinkedServerTestTable&#039;) SELECT AAA, BBB, CCC FROM tbl_table where 1 = 1 and AAA &gt;= &#039;2019-08-01&#039; and AAA &lt; &#039;2019-09-01&#039;; UPDATE OPENQUERY(L_TESTDB, &#039;SELECT NAME FROM LinkedServerTestTable\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=5028\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-5028","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/5028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5028"}],"version-history":[{"count":3,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/5028\/revisions"}],"predecessor-version":[{"id":5034,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/5028\/revisions\/5034"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}