{"id":67352,"date":"2015-10-05T23:13:48","date_gmt":"2015-10-05T15:13:48","guid":{"rendered":"http:\/\/www.xiaoyebailong.com\/?p=67352"},"modified":"2015-10-05T23:13:48","modified_gmt":"2015-10-05T15:13:48","slug":"sql%e6%9b%b4%e6%96%b0%e6%97%a5%e6%9c%9f%e6%97%b6%e9%97%b4%e5%ad%97%e6%ae%b5%e4%b8%ba%e7%a9%ba","status":"publish","type":"post","link":"http:\/\/www.xiaoyebailong.com\/index.php\/2015\/10\/05\/67352.htm","title":{"rendered":"sql\u66f4\u65b0\u65e5\u671f\u65f6\u95f4\u5b57\u6bb5\u4e3a\u7a7a"},"content":{"rendered":"

\u5728\u66f4\u65b0sqlserver\u6570\u636e\u5e93\u7684\u65f6\u5019\uff0c\u5728\u6570\u636e\u5e93\u4e2d\u76f4\u63a5\u624b\u52a8\u5220\u9664\u65e5\u671f\u65f6\u95f4\u662f\u4e0d\u884c\u7684\uff0c\u663e\u793a\u4e3a<\/p>\n

\"2\"<\/a><\/p>\n

\u6240\u4ee5\u5c31\u6709\u4e86\u4e0b\u5217\u66f4\u65b0<\/p>\n

\u5728\u66f4\u65b0\u7684\u65f6\u5019\u76f4\u63a5\u5199NULL<\/p>\n

\u800c\u5728\u6570\u636e\u5e93\u4e2d\u76f4\u63a5\u5199NULL\u4e00\u6837\u62a5\u9519<\/p>\n

\u4ee3\u7801\u4e3a\u5faa\u73af\u66f4\u65b0\u8868\u4e2d\u6240\u6709\u6570\u636e\u7684\u4e24\u4e2a\u65f6\u95f4\u5b57\u6bb5<\/p>\n

<%
\nsql = “select * from jz1024”
\nSet rs = Server.CreateObjzect(“ADODB.RecordSet”)
\nrs.Open sql,conn,1,1
\nfor i=1 to rs.recordcount<\/p>\n

sql1 = “select * from jz1024\u00a0where id=”&rs(“id”)&””
\nSet rs1 = Server.CreateObject(“ADODB.RecordSet”)
\nrs1.Open sql1,conn,1,3
\nrs1(“kftime”)=NULL
\nrs1(“qytime”)=NULL
\nrs1.update
\nrs1.close
\nset rs1=nothing<\/p>\n

rs.movenext
\nif rs.eof then exit for
\nnext
\nrs.close
\nset rs=nothing
\n%><\/p>\n","protected":false},"excerpt":{"rendered":"

\u5728\u66f4\u65b0sqlserver\u6570\u636e\u5e93\u7684\u65f6\u5019\uff0c\u5728\u6570\u636e\u5e93\u4e2d\u76f4\u63a5\u624b\u52a8\u5220\u9664\u65e5\u671f\u65f6\u95f4\u662f\u4e0d\u884c\u7684\uff0c\u663e\u793a\u4e3a \u6240\u4ee5\u5c31\u6709\u4e86\u4e0b\u5217\u66f4\u65b0 \u5728\u66f4\u65b0\u7684\u65f6\u5019\u76f4\u63a5\u5199NULL \u800c\u5728\u6570\u636e\u5e93\u4e2d\u76f4\u63a5\u5199NULL\u4e00\u6837\u62a5\u9519 \u4ee3\u7801\u4e3a\u5faa\u73af\u66f4\u65b0\u8868\u4e2d\u6240\u6709\u6570\u636e\u7684\u4e24\u4e2a\u65f6\u95f4\u5b57\u6bb5 <% sql = &#…<\/p>\n","protected":false},"author":1,"featured_media":67353,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[153,154],"topic":[],"class_list":["post-67352","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-153","tag-154"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/67352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/comments?post=67352"}],"version-history":[{"count":1,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/67352\/revisions"}],"predecessor-version":[{"id":67355,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/67352\/revisions\/67355"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media\/67353"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=67352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=67352"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=67352"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=67352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}