{"id":567,"date":"2010-10-01T07:30:09","date_gmt":"2010-10-01T07:30:09","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=567"},"modified":"2010-10-01T07:30:09","modified_gmt":"2010-10-01T07:30:09","slug":"%e4%bb%8e%e5%a4%9a%e4%b8%aaexcel%e4%b8%ad%e5%af%bc%e5%85%a5%e6%95%b0%e6%8d%ae%e5%85%a5%e5%ba%93","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2010\/10\/01\/%e4%bb%8e%e5%a4%9a%e4%b8%aaexcel%e4%b8%ad%e5%af%bc%e5%85%a5%e6%95%b0%e6%8d%ae%e5%85%a5%e5%ba%93\/","title":{"rendered":"\u4ece\u591a\u4e2aExcel\u4e2d\u5bfc\u5165\u6570\u636e\u5165\u5e93"},"content":{"rendered":"<pre lang=\"tsql\">\r\n\u6ce8\u610f\u7684\u4e00\u70b9\u65f6\u52a0\u4e2anewid\u5b57\u6bb5\uff0c\u4ee5\u8bb0\u5f55\u4f7f\u6bcf\u4e00\u6b21\u5bfc\u5165\u90fd\u4e0d\u540c\uff0c\u53ef\u6062\u590d\u4e4b\u7c7b\u7684\u64cd\u4f5c\r\n\r\n\r\nDECLARE @nid varchar(50)\r\nDECLARE @dt  datetime\r\n\r\n\r\nSET @nid = newid()\r\nSET @dt = getdate()\r\n\r\nINSERT INTO CustomerTemp\r\n\r\n\r\nSELECT   'zhuyunbo' AS Developer, \u9500\u552e\u90e8\u95e8 AS DepartmentName, \u65e5\u671f AS ReceiveDate,\r\n\u5de5\u53f7 AS WorkNo, \u987e\u95ee\u59d3\u540d AS SalesStaffName, \u5ba2\u6237\u59d3\u540d AS CustomerName, \u5730\u5740 AS Address,\r\n\u8054\u7cfb\u7535\u8bdd AS Tel, \u6027\u522b AS Sex, \u8eab\u9ad8\u4f53\u91cd\u5e74\u9f84 AS Height_Weight_Age,\r\n\u5ba2\u6237\u72b6\u6001 AS CustomerStatus, \u6c9f\u901a\u8bb0\u5f55  AS Record1,\r\nF12  AS Record2,\r\nNULL AS Record3,\r\n@dt AS ImportDate,\r\n@nid As nd\r\nFROM   OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source= \"G:\\\u53d1\u5c55\u90e8\u6570\u636e\u8d44\u6599\\\u53d1\u5c55\u90e8\u795d\u4e91\u6ce2\u8d44\u6599.xls\";Extended Properties= \"Excel 5.0;HDR=YES;Excel 8.0\";Persist Security Info=False ')...[\u5ba2\u6237\u8d44\u6599\u5e93$]\r\n\r\nprint @nid\r\n\r\nprint @dt\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6ce8\u610f\u7684\u4e00\u70b9\u65f6\u52a0\u4e2anewid\u5b57\u6bb5\uff0c\u4ee5\u8bb0\u5f55\u4f7f\u6bcf\u4e00\u6b21\u5bfc\u5165\u90fd\u4e0d\u540c\uff0c\u53ef\u6062\u590d\u4e4b\u7c7b\u7684\u64cd\u4f5c DECLARE @nid varc [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-567","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/567","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=567"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/567\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}