{"id":652,"date":"2018-04-19T20:34:12","date_gmt":"2018-04-19T12:34:12","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=652"},"modified":"2018-04-19T20:34:12","modified_gmt":"2018-04-19T12:34:12","slug":"%e7%94%a8sql%e8%af%ad%e5%8f%a5%e6%89%b9%e9%87%8f%e7%94%9f%e6%88%90%e4%b8%80%e4%b8%aa%e8%a1%a8%e7%9a%84insert%e8%af%ad%e5%8f%a5","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=652","title":{"rendered":"\u7528SQL\u8bed\u53e5\u6279\u91cf\u751f\u6210\u4e00\u4e2a\u8868\u7684INSERT\u8bed\u53e5"},"content":{"rendered":"

SELECT ‘INSERT INTO Previse(PreviseID,PreviseDate,PreviseInfo) VALUES
\n(‘+cast(PreviseID as varchar(10))+’,”’ + CONVERT(varchar(19), PreviseDate, 121) + ”’,
\n”’ + PreviseInfo + ”’)’ FROM Previse WHERE PreviseID > 100<\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT ‘INSERT INTO Previse(Previs…
Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-652","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=652"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/652\/revisions"}],"predecessor-version":[{"id":653,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/652\/revisions\/653"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}