{"id":2572,"date":"2017-01-19T15:56:15","date_gmt":"2017-01-19T07:56:15","guid":{"rendered":"http:\/\/jason695.why3s.tw\/wordpress\/?p=2572"},"modified":"2017-01-19T15:57:33","modified_gmt":"2017-01-19T07:57:33","slug":"%e8%ae%93-execute-%e5%8f%af%e4%bb%a5%e6%90%ad%e9%85%8d-select-into%ef%bc%8c%e8%80%8c%e4%b8%8d%e5%86%8d%e5%8f%aa%e6%9c%89-insert-into","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2017\/01\/19\/%e8%ae%93-execute-%e5%8f%af%e4%bb%a5%e6%90%ad%e9%85%8d-select-into%ef%bc%8c%e8%80%8c%e4%b8%8d%e5%86%8d%e5%8f%aa%e6%9c%89-insert-into\/","title":{"rendered":"\u8b93 Execute \u53ef\u4ee5\u642d\u914d Select Into\uff0c\u800c\u4e0d\u518d\u53ea\u6709 Insert into"},"content":{"rendered":"<p><a href=\"https:\/\/dotblogs.com.tw\/rainmaker\/2015\/02\/02\/148355\" target=\"_blank\">https:\/\/dotblogs.com.tw\/rainmaker\/2015\/02\/02\/148355<\/a><\/p>\n<pre class=\"lang:tsql decode:true \">select a.[name]\r\nfrom openrowset('SQLNCLI', 'Server=localhost;Trusted_Connection=yes;',\r\n'SET NOCOUNT ON;SET FMTONLY OFF;exec msdb..sp_help_job') AS a\r\nwhere [name] in ('JOB-113720-CTLFZ_1',\r\n\t\t\t\t'JOB-113720-CTLFZ_2',\r\n\t\t\t\t'JOB-113720-CTLFZ_3')\r\nand current_execution_status=4<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"lang:tsql decode:true \">--\u5efa\u7acb\u4e00\u500b LinkedServer \u9023\u81ea\u5df2\r\nsp_addlinkedserver @server = 'LOCALSERVER',  @srvproduct = '', @provider = 'SQLOLEDB', @datasrc = @@servername\r\n\r\nselect a.[name]\r\nFROM OPENQUERY(LOCALSERVER, 'EXEC(''exec msdb..sp_help_job'')')a\r\nwhere [name] in ('JOB-113720-CTLFZ_1',\r\n\t\t\t\t'JOB-113720-CTLFZ_2',\r\n\t\t\t\t'JOB-113720-CTLFZ_3')\r\nand current_execution_status=4\r\n<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>https:\/\/dotblogs.com.tw\/rainmaker\/2015\/02\/02\/148355 sel &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2017\/01\/19\/%e8%ae%93-execute-%e5%8f%af%e4%bb%a5%e6%90%ad%e9%85%8d-select-into%ef%bc%8c%e8%80%8c%e4%b8%8d%e5%86%8d%e5%8f%aa%e6%9c%89-insert-into\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">\u8b93 Execute \u53ef\u4ee5\u642d\u914d Select Into\uff0c\u800c\u4e0d\u518d\u53ea\u6709 Insert into<\/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-2572","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\/2572","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=2572"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2572\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=2572"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=2572"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=2572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}