{"id":2665,"date":"2018-09-27T11:11:06","date_gmt":"2018-09-27T03:11:06","guid":{"rendered":"https:\/\/jason695.why3s.tw\/wordpress\/?p=2665"},"modified":"2018-09-27T11:33:12","modified_gmt":"2018-09-27T03:33:12","slug":"link-server%e7%9a%84%e6%80%aa%e5%95%8f%e9%a1%8c","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2018\/09\/27\/link-server%e7%9a%84%e6%80%aa%e5%95%8f%e9%a1%8c\/","title":{"rendered":"LINK SERVER\u7684\u602a\u554f\u984c"},"content":{"rendered":"<p>\u60c5\u5883:<br \/>\nLINK\u5230\u53e6\u4e00\u53f0\u7684SP\u5c07SELECT\u7d50\u679c\u53d6\u56de\u5165TEMP,\u4f46\u6703\u51fa\u73fe&#8221;\u7121\u6cd5\u57f7\u884c\u4f5c\u696d\uff0c\u56e0\u70ba\u9023\u7d50\u4f3a\u670d\u5668 &#8220;ESWEB1&#8221; \u7684 OLE DB \u63d0\u4f9b\u8005 &#8220;SQLNCLI10&#8221; \u7121\u6cd5\u958b\u59cb\u5206\u6563\u5f0f\u4ea4\u6613\u3002&#8221;\u7684\u932f\u8aa4\u8a0a\u606f<br \/>\n\u6539DTC\u4e5f\u7121\u6548(<a href=\"https:\/\/dotblogs.com.tw\/abbee\/2017\/01\/20\/163135\">https:\/\/dotblogs.com.tw\/abbee\/2017\/01\/20\/163135<\/a>)<\/p>\n<pre class=\"lang:tsql decode:true \">EXEC sp_configure\nexec sp_configure 'show advanced options', 1;\nRECONFIGURE;\nexec sp_configure 'Ad Hoc Distributed Queries', 1;\nRECONFIGURE;\nGO<\/pre>\n<p>\u539f\u8a9e\u6cd5:<\/p>\n<pre class=\"lang:tsql decode:true \">insert into #tmp\nexec [link].SP<\/pre>\n<p>\u6539\u70baOPENQUERY:<\/p>\n<pre class=\"lang:tsql decode:true \">insert into #tmp\nselect * from openquery([link],'SET FMTONLY OFF;SET NOCOUNT ON;exec SP')<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u60c5\u5883: LINK\u5230\u53e6\u4e00\u53f0\u7684SP\u5c07SELECT\u7d50\u679c\u53d6\u56de\u5165TEMP,\u4f46\u6703\u51fa\u73fe&#8221;\u7121\u6cd5\u57f7\u884c\u4f5c\u696d\uff0c\u56e0\u70ba\u9023\u7d50\u4f3a &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2018\/09\/27\/link-server%e7%9a%84%e6%80%aa%e5%95%8f%e9%a1%8c\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">LINK SERVER\u7684\u602a\u554f\u984c<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[47],"tags":[],"class_list":["post-2665","post","type-post","status-publish","format-standard","hentry","category-sql-server","no-featured-image"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/comments?post=2665"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2665\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=2665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=2665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=2665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}