{"id":68599,"date":"2020-06-12T11:42:26","date_gmt":"2020-06-12T03:42:26","guid":{"rendered":"http:\/\/www.xiaoyebailong.com\/?p=68599"},"modified":"2020-06-12T11:42:28","modified_gmt":"2020-06-12T03:42:28","slug":"sql%e7%a9%ba%e5%80%bc%e5%88%a4%e6%96%ad%e5%bf%85%e9%a1%bb%e4%b8%a5%e8%b0%a8","status":"publish","type":"post","link":"http:\/\/www.xiaoyebailong.com\/index.php\/2020\/06\/12\/68599.htm","title":{"rendered":"SQL\u7a7a\u503c\u5224\u65ad\u5fc5\u987b\u4e25\u8c28"},"content":{"rendered":"\n<p>\u5728\u5224\u65adMSSQL\u91cc\u9762\u4e3a\u7a7a\u503c\u7684\u65f6\u5019\u5fc5\u987b\u4e25\u8c28\uff0c\u6709\u4e2a\u503c\u4e00\u4e2a\u662f\u4e3aNULL\u4e00\u4e2a\u4e3a\u7a7a\uff0c\u90fd\u5fc5\u987b\u5224\u65ad\u624d\u884c<\/p>\n\n\n\n<p>if IsNull(rs(&#8220;pic&#8221;)) or rs(&#8220;pic&#8221;)=&#8221;&#8221; then<br>response.Write &#8220;\u7a7a\u503c&#8221;<br>response.end<br>end if<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u5224\u65adMSSQL\u91cc\u9762\u4e3a\u7a7a\u503c\u7684\u65f6\u5019\u5fc5\u987b\u4e25\u8c28\uff0c\u6709\u4e2a\u503c\u4e00\u4e2a\u662f\u4e3aNULL\u4e00\u4e2a\u4e3a\u7a7a\uff0c\u90fd\u5fc5\u987b\u5224\u65ad\u624d\u884c if IsNull(rs(&#8220;pic&#8221;)) or rs(&#8220;pic&#8221;)=&#8221;&#8221; th&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"topic":[],"class_list":["post-68599","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/68599","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=68599"}],"version-history":[{"count":1,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/68599\/revisions"}],"predecessor-version":[{"id":68600,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/68599\/revisions\/68600"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=68599"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=68599"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=68599"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=68599"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}