{"id":351,"date":"2022-05-23T14:42:01","date_gmt":"2022-05-23T06:42:01","guid":{"rendered":"https:\/\/www.keioi.cn\/?p=351"},"modified":"2022-05-23T15:01:35","modified_gmt":"2022-05-23T07:01:35","slug":"sql%e6%b8%b8%e6%a0%87","status":"publish","type":"post","link":"https:\/\/www.keioi.cn\/archives\/351","title":{"rendered":"SQL\u6e38\u6807"},"content":{"rendered":"\n<p>\u63a5 <a href=\"https:\/\/www.keioi.cn\/2022\/01\/20\/sql%E6%96%B0%E5%BB%BA%E4%B8%A4%E4%B8%AA%E8%A1%A8%E5%B9%B6%E4%BD%BF%E7%94%A8%E8%A7%A6%E5%8F%91%E5%99%A8%E3%80%82\">sql\u89e6\u53d1\u5668\uff0c\u89c6\u56fe\u7b49<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>declare @name nvarchar(100) ,@stat int<br>declare ctest1 cursor scroll for  &#8211;\u6e38\u6807<br>select bkname,stat from books<br>open ctest1<br>fetch next from ctest1 into @name,@stat<br>while (@@FETCH_STATUS=0)<br>begin<br>&#8211;select @name ,@stat<br>if (LEFT(@name,1)=&#8217;\u4e09&#8217;)<br>begin<br>select @name+&#8217;,&#8217;+cast(@stat as varchar(10))<br>end<br>&#8211;update books set bkname=&#8217;\u4e09\u56fd&#8217; where bkname=&#8217;\u4e09\u56fd1&#8242;<br>fetch next from ctest1 into @name,@stat<br>end<br>close ctest1<br>deallocate ctest1;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.keioi.cn\/wp-content\/uploads\/2022\/05\/20220523145903.png\" alt=\"\" class=\"wp-image-357\" width=\"510\" height=\"599\" srcset=\"https:\/\/www.keioi.cn\/wp-content\/uploads\/2022\/05\/20220523145903.png 510w, https:\/\/www.keioi.cn\/wp-content\/uploads\/2022\/05\/20220523145903-255x300.png 255w\" sizes=\"auto, (max-width: 510px) 100vw, 510px\" \/><figcaption>\u663e\u793a\u7ed3\u679c<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u63a5 sql\u89e6\u53d1\u5668\uff0c\u89c6\u56fe\u7b49 dec&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-351","post","type-post","status-publish","format-standard","hentry","category-4"],"_links":{"self":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/comments?post=351"}],"version-history":[{"count":3,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/351\/revisions"}],"predecessor-version":[{"id":358,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/351\/revisions\/358"}],"wp:attachment":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/media?parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/categories?post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/tags?post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}