{"id":323,"date":"2022-04-06T11:37:41","date_gmt":"2022-04-06T03:37:41","guid":{"rendered":"https:\/\/www.keioi.cn\/?p=323"},"modified":"2022-04-06T11:37:41","modified_gmt":"2022-04-06T03:37:41","slug":"sql%e6%97%a5%e6%9c%9f%e6%95%b0%e5%ad%97%e6%9b%bf%e6%8d%a2%e5%ad%97%e6%af%8d%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/www.keioi.cn\/archives\/323","title":{"rendered":"SQL\u65e5\u671f\u6570\u5b57\u66ff\u6362\u5b57\u6bcd\u51fd\u6570"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>CREATE FUNCTION fn_numtoletter<br>(<br>@key NVARCHAR(10)<br>)<br>RETURNS VARCHAR(10)<br>AS<br>BEGIN<br>DECLARE @code VARCHAR(10)<br>if(LEN(@key)=1)<br>begin<br>SET @code=@key<br>end<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>if(LEN(@key)=2) \nbegin\n\nSET @code=case \nwhen @key='00' then '0'\nwhen @key='01' then '1'\nwhen @key='02' then '2'\nwhen @key='03' then '3'\nwhen @key='04' then '4'\nwhen @key='05' then '5'\nwhen @key='06' then '6'\nwhen @key='07' then '7'\nwhen @key='08' then '8'\nwhen @key='09' then '9'\nwhen @key='10' then 'A'\nwhen @key='11' then 'B'\nwhen @key='12' then 'C'\nwhen @key='13' then 'D'\nwhen @key='14' then 'E'\nwhen @key='15' then 'F'\nwhen @key='16' then 'G'\nwhen @key='17' then 'H'\nwhen @key='18' then 'I'\nwhen @key='19' then 'J'\nwhen @key='20' then 'K'\nwhen @key='21' then 'L'\nwhen @key='22' then 'M'\nwhen @key='23' then 'N'\nwhen @key='24' then 'O'\nwhen @key='25' then 'P'\nwhen @key='26' then 'Q'\nwhen @key='27' then 'R'\nwhen @key='28' then 'S'\nwhen @key='29' then 'T'\nwhen @key='30' then 'U'\nwhen @key='31' then 'V'\nelse '\u5927\u4e8e31' end\n\nend\n\nRETURN  @code<\/code><\/pre>\n\n\n\n<p>END<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>CREATE FUNCTION &#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-323","post","type-post","status-publish","format-standard","hentry","category-4"],"_links":{"self":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/323","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=323"}],"version-history":[{"count":1,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/323\/revisions"}],"predecessor-version":[{"id":324,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/323\/revisions\/324"}],"wp:attachment":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/media?parent=323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/categories?post=323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/tags?post=323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}