{"id":354,"date":"2010-09-21T13:38:54","date_gmt":"2010-09-21T05:38:54","guid":{"rendered":"http:\/\/blog.infinity.idv.tw\/index.php\/2010\/09\/21\/sql2005%e5%8c%af%e5%85%a5excel%e6%b3%a8%e6%84%8f%e4%ba%8b%e9%a0%85\/"},"modified":"2011-03-22T16:07:15","modified_gmt":"2011-03-22T08:07:15","slug":"sql2005%e5%8c%af%e5%85%a5excel%e6%b3%a8%e6%84%8f%e4%ba%8b%e9%a0%85","status":"publish","type":"post","link":"http:\/\/blog.infinity.idv.tw\/?p=354","title":{"rendered":"SQL2005\u532f\u5165EXCEL\u6ce8\u610f\u4e8b\u9805"},"content":{"rendered":"<p>SQL2005\u532f\u5165EXCEL\u6ce8\u610f\u4e8b\u9805<\/p>\n<p>\u9019\u5169\u5929\u6e2c\u8a66\u5f9eSQLA\u4f7f\u7528SQL\u6307\u4ee4\u67e5\u8a62\u7684\u8cc7\u6599\u532f\u51fa\u6210EXCEL\uff0c\u7136\u5f8c\u518d\u532f\u5165SQLB\u540c\u500b\u8cc7\u6599\u8868\u5167\uff0c\u53ef\u662f\u4e00\u76f4\u5931\u6557\uff0c\u5f8c\u4f86\u540c\u4e8b\u8aaa\uff0cEXCEL\u8981\u532f\u5165SQL2005\uff0c\u5fc5\u9808\u628aEXCEL\u5167\u7684SHEET NAME\u6539\u6210\u4f60\u8981\u532f\u5165\u7684TABLE NAME\uff0c\u624d\u53ef\u4ee5\u6b63\u78ba\u532f\u5165\u3002<\/p>\n<p>\u532f\u51faEXCEL:<\/p>\n<p><a href=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/1.jpg\"><img loading=\"lazy\" style=\"border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px\" title=\"1\" border=\"0\" alt=\"1\" src=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/1_thumb.jpg\" width=\"514\" height=\"507\" \/><\/a> <\/p>\n<p>\u9078\u64c7\u4f86\u6e90(\u5f9eSQL\u532f\u51fa)<\/p>\n<p><a href=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/2.jpg\"><img loading=\"lazy\" style=\"border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px\" title=\"2\" border=\"0\" alt=\"2\" src=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/2_thumb.jpg\" width=\"535\" height=\"348\" \/><\/a> <\/p>\n<p>\u9078\u64c7\u76ee\u7684\u5730(\u532f\u51fa\u5230EXCEL)<\/p>\n<p><a href=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/3.jpg\"><img loading=\"lazy\" style=\"border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px\" title=\"3\" border=\"0\" alt=\"3\" src=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/3_thumb.jpg\" width=\"539\" height=\"317\" \/><\/a> <\/p>\n<p>\u9019\u908a\u6211\u53ea\u8981\u88e1\u9762\u7684\u4e00\u5c0f\u6bb5\u8cc7\u6599\uff0c\u6240\u4ee5\u7528SQL\u6307\u4ee4\u65b9\u5f0f\u7be9\u9078\u53d6\u8cc7\u6599<\/p>\n<p><a href=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/4.jpg\"><img loading=\"lazy\" style=\"border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px\" title=\"4\" border=\"0\" alt=\"4\" src=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/4_thumb.jpg\" width=\"536\" height=\"339\" \/><\/a> <\/p>\n<p><a href=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/5.jpg\"><img loading=\"lazy\" style=\"border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px\" title=\"5\" border=\"0\" alt=\"5\" src=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/5_thumb.jpg\" width=\"537\" height=\"194\" \/><\/a> <\/p>\n<p><a href=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/6.jpg\"><img loading=\"lazy\" style=\"border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px\" title=\"6\" border=\"0\" alt=\"6\" src=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/6_thumb.jpg\" width=\"538\" height=\"259\" \/><\/a> <\/p>\n<p><a href=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/7.jpg\"><img loading=\"lazy\" style=\"border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px\" title=\"7\" border=\"0\" alt=\"7\" src=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/7_thumb.jpg\" width=\"540\" height=\"255\" \/><\/a> <\/p>\n<p>\u5b8c\u6210\u532f\u51fa\uff0c\u53ef\u5728D\u69fd\u770b\u5230\u8a72EXCEL\u6a94\u6848\u3002<\/p>\n<p><a href=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/8.jpg\"><img loading=\"lazy\" style=\"border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px\" title=\"8\" border=\"0\" alt=\"8\" src=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/8_thumb.jpg\" width=\"534\" height=\"487\" \/><\/a> <\/p>\n<p>&#160;<\/p>\n<p>\u532f\u5165EXCEL<\/p>\n<p>\u5047\u8a2d\u8981\u6703\u5165123\u8cc7\u6599\u5eab\u5e95\u4e0b\u7684456 TABLE\uff0c\u90a3EXCEL\u5167\u7684Sheet Name \u8981\u6539\u6210 456 \u624d\u80fd\u6b63\u78ba\u532f\u5165\uff0c\u532f\u5165\u65b9\u5f0f\u5982\u540c\u4e0a\u9762\u532f\u51fa\uff0c\u53ea\u662f\u4f86\u6e90\u8207\u76ee\u7684\u5730\u5c0d\u8abf\u800c\u5df2\u3002<\/p>\n<p><a href=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/1_3.jpg\"><img loading=\"lazy\" style=\"border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px\" title=\"1\" border=\"0\" alt=\"1\" src=\"http:\/\/blog.infinity.idv.tw\/blog-img\/SQL2005EXCEL_A517\/1_thumb_3.jpg\" width=\"450\" height=\"220\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL2005\u532f\u5165EXCEL\u6ce8\u610f\u4e8b\u9805<\/p>\n<p>\u9019\u5169\u5929\u6e2c\u8a66\u5f9eSQLA\u4f7f\u7528SQL\u6307\u4ee4\u67e5\u8a62\u7684\u8cc7\u6599\u532f\u51fa\u6210EXCEL\uff0c\u7136\u5f8c\u518d\u532f\u5165SQLB\u540c\u500b\u8cc7\u6599\u8868\u5167\uff0c\u53ef\u662f\u4e00\u76f4\u5931\u6557\uff0c\u5f8c\u4f86\u540c\u4e8b\u8aaa\uff0cEXCEL\u8981\u532f\u5165SQL2005\uff0c\u5fc5\u9808\u628aEXCEL\u5167\u7684SHEET NAME\u6539\u6210\u4f60\u8981\u532f\u5165\u7684TABLE NAME\uff0c\u624d\u53ef\u4ee5\u6b63\u78ba\u532f\u5165\u3002<\/p>\n<p>\u532f\u51faEXCEL:<\/p>\n<\/p>\n<p>\u9078\u64c7\u4f86\u6e90(\u5f9eSQL\u532f\u51fa)<\/p>\n<\/p>\n<p>\u9078\u64c7\u76ee\u7684\u5730(\u532f\u51fa\u5230EXCEL)<\/p>\n<\/p>\n<p>\u9019\u908a\u6211\u53ea\u8981\u88e1\u9762\u7684\u4e00\u5c0f\u6bb5\u8cc7\u6599\uff0c\u6240\u4ee5\u7528SQL\u6307\u4ee4\u65b9\u5f0f\u7be9\u9078\u53d6\u8cc7\u6599<\/p>\n<\/p>\n<\/p>\n<p>\u5b8c\u6210\u532f\u51fa\uff0c\u53ef\u5728D\u69fd\u770b\u5230\u8a72EXCEL\u6a94\u6848\u3002<\/p>\n<\/p>\n<p>&#160;<\/p>\n<p>\u532f\u5165EXCEL<\/p>\n<p>\u5047\u8a2d\u8981\u6703\u5165123\u8cc7\u6599\u5eab\u5e95\u4e0b\u7684456 TABLE\uff0c\u90a3EXCEL\u5167\u7684Sheet Name \u8981\u6539\u6210 456 \u624d\u80fd\u6b63\u78ba\u532f\u5165\uff0c\u532f\u5165\u65b9\u5f0f\u5982\u540c\u4e0a\u9762\u532f\u51fa\uff0c\u53ea\u662f\u4f86\u6e90\u8207\u76ee\u7684\u5730\u5c0d\u8abf\u800c\u5df2\u3002<\/p><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[27],"tags":[331],"_links":{"self":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/354"}],"collection":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=354"}],"version-history":[{"count":1,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/354\/revisions"}],"predecessor-version":[{"id":440,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/354\/revisions\/440"}],"wp:attachment":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=354"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}