{"id":2058,"date":"2011-11-30T11:44:29","date_gmt":"2011-11-30T03:44:29","guid":{"rendered":"http:\/\/jason695.why3s.tw\/wordpress\/?p=2058"},"modified":"2011-12-14T14:04:48","modified_gmt":"2011-12-14T06:04:48","slug":"sql%e6%95%88%e8%83%bd%e8%aa%bf%e6%a0%a1-%e4%b9%8b-%e4%b8%80","status":"publish","type":"post","link":"https:\/\/jason695.why3s.tw\/wordpress\/2011\/11\/30\/sql%e6%95%88%e8%83%bd%e8%aa%bf%e6%a0%a1-%e4%b9%8b-%e4%b8%80\/","title":{"rendered":"SQL\u6548\u80fd\u8abf\u6821 \u4e4b \u4e00"},"content":{"rendered":"<p>SQL\u7d50\u69cb\u5982\u4e0b\uff1a<\/p>\n<pre lang=\"SQL\">\r\nSELECT * FROM A\r\nUNION ALL\r\nSELECT * FROM B\r\n<\/pre>\n<p>\u82e5\u57f7\u884c\u904e\u4e45\uff0c\u6709\u53ef\u80fd\u662f\u56e0\u70ba\u5728UNION ALL\u6bd4\u5c0d\u8cc7\u6599\u82b1\u4e86\u592a\u591a\u6548\u80fd\uff0c<br \/>\n\u6216\u8a31\u53ef\u4ee5\u6539\u7528\u4ee5\u4e0b\u7684\u5beb\u6cd5<\/p>\n<pre lang=\"SQL\">\r\nselect *\r\ninto #temp\r\nfrom A\r\n\r\ninsert into #temp\r\nselect * from B\r\n\r\nselect * from #temp\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQL\u7d50\u69cb\u5982\u4e0b\uff1a SELECT * FROM A UNION ALL SELECT * FROM B \u82e5\u57f7\u884c\u904e &hellip; <a href=\"https:\/\/jason695.why3s.tw\/wordpress\/2011\/11\/30\/sql%e6%95%88%e8%83%bd%e8%aa%bf%e6%a0%a1-%e4%b9%8b-%e4%b8%80\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">SQL\u6548\u80fd\u8abf\u6821 \u4e4b \u4e00<\/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-2058","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\/2058","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=2058"}],"version-history":[{"count":0,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/posts\/2058\/revisions"}],"wp:attachment":[{"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/media?parent=2058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/categories?post=2058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jason695.why3s.tw\/wordpress\/wp-json\/wp\/v2\/tags?post=2058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}