SQL数字转英文函数代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】 SQL数字转英文函数
作者:maco_wang / 发布于2012/2/8/ 516
<div>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- </span><span style="color: green; font-family: 宋体; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes; mso-ascii-font-family: "Courier New"; mso-hansi-font-family: "Courier New"; mso-bidi-font-family: "Courier New";">数字转英文</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- =============================================</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- Author:<span style="mso-spacerun: yes;">     </span>qianjin036a</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- Create date:06/14/2008 02:27:17</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- Description:Arabic numerals to English</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- =============================================</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">go</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">--</span><span style="color: green; font-family: 宋体; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes; mso-ascii-font-family: "Courier New"; mso-hansi-font-family: "Courier New"; mso-bidi-font-family: "Courier New";">创建函数</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">CREATE</span><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> <span style="color: blue;">FUNCTION</span> Digit2English </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: gray; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">(</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-tab-count: 1;">    </span>@arabia <span style="color: blue;">decimal</span><span style="color: gray;">(</span>38<span style="color: gray;">,</span>17<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: gray; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">)</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">RETURNS</span><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> <span style="color: blue;">varchar</span><span style="color: gray;">(</span>1000<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">AS</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">BEGIN</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">declare</span> @atoe <span style="color: blue;">table</span><span style="color: gray;">(</span>a <span style="color: blue;">int</span><span style="color: gray;">,</span>e <span style="color: blue;">varchar</span><span style="color: gray;">(</span>10<span style="color: gray;">))</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">insert</span> <span style="color: blue;">into</span> @atoe <span style="color: blue;">select</span> 0<span style="color: gray;">,</span><span style="color: red;">'zero'</span><span style="mso-spacerun: yes;">   </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 1<span style="color: gray;">,</span><span style="color: red;">'one'</span> </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 2<span style="color: gray;">,</span><span style="color: red;">'two'</span><span style="mso-spacerun: yes;">            </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 3<span style="color: gray;">,</span><span style="color: red;">'three'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 4<span style="color: gray;">,</span><span style="color: red;">'four'</span><span style="mso-spacerun: yes;">           </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 5<span style="color: gray;">,</span><span style="color: red;">'five'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 6<span style="color: gray;">,</span><span style="color: red;">'six'</span><span style="mso-spacerun: yes;">            </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 7<span style="color: gray;">,</span><span style="color: red;">'seven'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 8<span style="color: gray;">,</span><span style="color: red;">'eight'</span><span style="mso-spacerun: yes;">          </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 9<span style="color: gray;">,</span><span style="color: red;">'nine'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: red; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">declare</span> @integer <span style="color: blue;">bigint</span><span style="color: gray;">,</span>@trillion <span style="color: blue;">int</span><span style="color: gray;">,</span>@billion <span style="color: blue;">int</span><span style="color: gray;">,</span>@million <span style="color: blue;">int</span><span style="color: gray;">,</span>@thousand <span style="color: blue;">int</span><span style="color: gray;">,</span>@hundred <span style="color: blue;">int</span><span style="color: gray;">,</span>@english <span style="color: blue;">varchar</span><span style="color: gray;">(</span>1000<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: gray; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">select</span> @integer<span style="color: gray;">=</span>@arabia<span style="color: gray;">,</span>@english<span style="color: gray;">=</span><span style="color: red;">''</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">select</span> @trillion<span style="color: gray;">=</span>@integer <span style="color: gray;">%</span> 1000000000000000<span style="color: gray;">/</span>1000000000000<span style="color: gray;">,</span>@billion<span style="color: gray;">=</span>@integer <span style="color: gray;">%</span> 1000000000000<span style="color: gray;">/</span>1000000000<span style="color: gray;">,</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span>@million<span style="color: gray;">=</span>@integer <span style="color: gray;">%</span> 1000000000<span style="color: gray;">/</span>1000000<span style="color: gray;">,</span>@thousand<span style="color: gray;">=(</span>@integer <span style="color: gray;">%</span> 1000000<span style="color: gray;">)/</span>1000<span style="color: gray;">,</span>@hundred<span style="color: gray;">=(</span>@integer <span style="color: gray;">%</span> 1000<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">if</span> @trillion<span style="color: gray;">></span>0</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">set</span> @english<span style="color: gray;">=</span>@english <span style="color: gray;">+</span> dbo<span style="color: gray;">.</span>ThreeDigit<span style="color: gray;">(</span>@trillion<span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">'trillion '</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">if</span> @billion<span style="color: gray;">></span>0</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">set</span> @english<span style="color: gray;">=</span>@english <span style="color: gray;">+</span> dbo<span style="color: gray;">.</span>ThreeDigit<span style="color: gray;">(</span>@billion<span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">'billion '</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">if</span> @million<span style="color: gray;">></span>0</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">set</span> @english<span style="color: gray;">=</span>@english <span style="color: gray;">+</span> dbo<span style="color: gray;">.</span>ThreeDigit<span style="color: gray;">(</span>@million<span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">'million '</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">if</span> @thousand<span style="color: gray;">></span>0</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">set</span> @english<span style="color: gray;">=</span>@english <span style="color: gray;">+</span> dbo<span style="color: gray;">.</span>ThreeDigit<span style="color: gray;">(</span>@thousand<span style="color: gray;">)</span> <span style="color: gray;">+</span> <span style="color: red;">'thousand '</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">if</span> @hundred<span style="color: gray;">></span>0</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">set</span> @english<span style="color: gray;">=</span>@english <span style="color: gray;">+</span> dbo<span style="color: gray;">.</span>ThreeDigit<span style="color: gray;">(</span>@hundred<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">if</span> @english<span style="color: gray;">=</span><span style="color: red;">''</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">set</span> @english<span style="color: gray;">=</span><span style="color: red;">'zero '</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">if</span> @arabia<span style="color: gray;">-</span>@integer<span style="color: gray;">></span>0.000000000</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">begin</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">            </span><span style="color: blue;">declare</span> @decimal <span style="color: blue;">decimal</span><span style="color: gray;">(</span>18<span style="color: gray;">,</span>17<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">            </span><span style="color: blue;">select</span> @english<span style="color: gray;">=</span>@english<span style="color: gray;">+</span><span style="color: red;">'point '</span><span style="color: gray;">,</span>@decimal<span style="color: gray;">=</span>@arabia<span style="color: gray;">-</span>@integer</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="mso-spacerun: yes;">    </span><span style="color: blue;">while</span> @decimal<span style="color: gray;">></span>0.0</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">                </span><span style="color: blue;">begin</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">                    </span><span style="color: blue;">select</span> @english<span style="color: gray;">=</span>@english<span style="color: gray;">+</span>e<span style="color: gray;">+</span><span style="color: red;">' '</span> <span style="color: blue;">from</span> @atoe <span style="color: blue;">where</span> <span style="color: fuchsia;">cast</span><span style="color: gray;">(</span>@decimal<span style="color: gray;">*</span>10 <span style="color: blue;">as</span> <span style="color: blue;">int</span><span style="color: gray;">)=</span>a</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">                    </span><span style="color: blue;">set</span> @decimal<span style="color: gray;">=</span>@decimal<span style="color: gray;">*</span>10<span style="color: gray;">-</span><span style="color: fuchsia;">cast</span><span style="color: gray;">(</span>@decimal<span style="color: gray;">*</span>10 <span style="color: blue;">as</span> <span style="color: blue;">int</span><span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">                </span><span style="color: blue;">end</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">end</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">return</span> @english</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">END</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">GO</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- =============================================</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- Author:<span style="mso-spacerun: yes;">      </span>qianjin036a</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- Create date: 06/14/2008 02:27:17</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- Description: Three Digit Arabic numerals to English</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">-- =============================================</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">CREATE</span><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> <span style="color: blue;">FUNCTION</span> ThreeDigit </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: gray; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">(</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span>@integer <span style="color: blue;">int</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: gray; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">)</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">RETURNS</span><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> <span style="color: blue;">varchar</span><span style="color: gray;">(</span>100<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">WITH</span><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> <span style="color: blue;">EXECUTE</span> <span style="color: blue;">AS</span> CALLER</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">AS</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">BEGIN</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">declare</span> @atoe <span style="color: blue;">table</span><span style="color: gray;">(</span>a <span style="color: blue;">int</span><span style="color: gray;">,</span>e <span style="color: blue;">varchar</span><span style="color: gray;">(</span>10<span style="color: gray;">))</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">insert</span> <span style="color: blue;">into</span> @atoe <span style="color: blue;">select</span> 0<span style="color: gray;">,</span><span style="color: red;">'zero'</span><span style="mso-spacerun: yes;">   </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 1<span style="color: gray;">,</span><span style="color: red;">'one'</span> </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 2<span style="color: gray;">,</span><span style="color: red;">'two'</span><span style="mso-spacerun: yes;">            </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 3<span style="color: gray;">,</span><span style="color: red;">'three'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;">   </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 4<span style="color: gray;">,</span><span style="color: red;">'four'</span><span style="mso-spacerun: yes;">           </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 5<span style="color: gray;">,</span><span style="color: red;">'five'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 6<span style="color: gray;">,</span><span style="color: red;">'six'</span><span style="mso-spacerun: yes;">            </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 7<span style="color: gray;">,</span><span style="color: red;">'seven'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 8<span style="color: gray;">,</span><span style="color: red;">'eight'</span><span style="mso-spacerun: yes;">          </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 9<span style="color: gray;">,</span><span style="color: red;">'nine'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 10<span style="color: gray;">,</span><span style="color: red;">'ten'</span><span style="mso-spacerun: yes;">           </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 11<span style="color: gray;">,</span><span style="color: red;">'eleven'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 12<span style="color: gray;">,</span><span style="color: red;">'twelve'</span><span style="mso-spacerun: yes;">        </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 13<span style="color: gray;">,</span><span style="color: red;">'thirteen'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 14<span style="color: gray;">,</span><span style="color: red;">'fourteen'</span><span style="mso-spacerun: yes;">      </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 15<span style="color: gray;">,</span><span style="color: red;">'fifteen'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 16<span style="color: gray;">,</span><span style="color: red;">'sixteen'</span><span style="mso-spacerun: yes;">       </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 17<span style="color: gray;">,</span><span style="color: red;">'seventeen'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 18<span style="color: gray;">,</span><span style="color: red;">'eighteen'</span><span style="mso-spacerun: yes;">      </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 19<span style="color: gray;">,</span><span style="color: red;">'nineteen'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 20<span style="color: gray;">,</span><span style="color: red;">'twenty'</span><span style="mso-spacerun: yes;">        </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 30<span style="color: gray;">,</span><span style="color: red;">'thirty'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 40<span style="color: gray;">,</span><span style="color: red;">'forty'</span><span style="mso-spacerun: yes;">         </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 50<span style="color: gray;">,</span><span style="color: red;">'fifty'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 60<span style="color: gray;">,</span><span style="color: red;">'sixty'</span><span style="mso-spacerun: yes;">         </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 70<span style="color: gray;">,</span><span style="color: red;">'severty'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 80<span style="color: gray;">,</span><span style="color: red;">'eighty'</span><span style="mso-spacerun: yes;">        </span><span style="color: blue;">union</span> <span style="color: gray;">all</span> <span style="color: blue;">select</span> 90<span style="color: gray;">,</span><span style="color: red;">'ninety'</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: red; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">declare</span> @english <span style="color: blue;">varchar</span><span style="color: gray;">(</span>100<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">set</span> @english<span style="color: gray;">=</span><span style="color: red;">''</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">if</span> @integer<span style="color: gray;">></span>99</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">begin</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">            </span><span style="color: blue;">select</span> @english<span style="color: gray;">=</span>e<span style="color: gray;">+</span><span style="color: red;">' hundred '</span> <span style="color: blue;">from</span> @atoe <span style="color: blue;">where</span> @integer<span style="color: gray;">/</span>100<span style="color: gray;">=</span>a</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">            </span><span style="color: blue;">set</span> @integer<span style="color: gray;">=</span>@integer <span style="color: gray;">%</span> 100</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">            </span><span style="color: blue;">if</span> @integer<span style="color: gray;">></span>0</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">                </span><span style="color: blue;">set</span> @english<span style="color: gray;">=</span>@english<span style="color: gray;">+</span><span style="color: red;">'and '</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">end</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">if</span> @integer<span style="color: gray;"><=</span>20 <span style="color: gray;">and</span> @integer<span style="color: gray;">></span>0</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">select</span> @english<span style="color: gray;">=</span>@english<span style="color: gray;">+</span>e<span style="color: gray;">+</span><span style="color: red;">' '</span> <span style="color: blue;">from</span> @atoe <span style="color: blue;">where</span> @integer<span style="color: gray;">=</span>a</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">if</span> @integer<span style="color: gray;">></span>20</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">begin</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">            </span><span style="color: blue;">select</span> @english<span style="color: gray;">=</span>@english<span style="color: gray;">+</span>e<span style="color: gray;">+</span><span style="color: red;">' '</span> <span style="color: blue;">from</span> @atoe <span style="color: blue;">where</span> @integer<span style="color: gray;">/</span>10<span style="color: gray;">*</span>10<span style="color: gray;">=</span>a</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">            </span><span style="color: blue;">set</span> @integer<span style="color: gray;">=</span>@integer <span style="color: gray;">%</span> 10</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">            </span><span style="color: blue;">if</span> @integer<span style="color: gray;">></span>0</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">                </span><span style="color: blue;">select</span> @english<span style="color: gray;">=</span>@english<span style="color: gray;">+</span>e<span style="color: gray;">+</span><span style="color: red;">' '</span> <span style="color: blue;">from</span> @atoe <span style="color: blue;">where</span> @integer<span style="color: gray;">=</span>a</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">        </span><span style="color: blue;">end</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"><span style="mso-spacerun: yes;">    </span><span style="color: blue;">RETURN</span> @english</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">END</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">GO</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">select</span><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> dbo<span style="color: gray;">.</span>digit2english<span style="color: gray;">(</span>123456789987654.321<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">union</span><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> <span style="color: gray;">all</span> <span style="color: blue;">select</span> dbo<span style="color: gray;">.</span>digit2english<span style="color: gray;">(</span>120045080045054.8412<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: blue; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">union</span><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> <span style="color: gray;">all</span> <span style="color: blue;">select</span> dbo<span style="color: gray;">.</span>digit2english<span style="color: gray;">(</span>0.0102541<span style="color: gray;">)</span></span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: gray; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;"> </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">go</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">/*</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">---------------------------------------------------------------------</span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">one hundred and twenty three trillion four hundred and fifty six billion seven hundred and eighty nine million nine hundred and eighty seven thousand six hundred and fifty four point three two one </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">one hundred and twenty trillion forty five billion eighty million forty five thousand fifty four point eight four one two </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">zero point zero one zero two five four one </span>
<p align="left" class="MsoNormal" style="margin: 0cm 0cm 0pt; text-align: left; mso-layout-grid-align: none;"><span lang="EN-US" style="color: green; font-family: "Courier New"; font-size: 10pt; mso-font-kerning: 0pt; mso-no-proof: yes;">*/</span>
</div>
试试其它关键字
　数字转英文　
同语言下
可能有用的
maco_wang贡献的其它代码(36)