获取汉语拼音简码代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】获取汉语拼音简码
作者:Dezai.CN / 发布于2011/8/1/ 494
<div>
<div><span style="color: rgb(0,0,255)">alter</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">FUNCTION</span><span style="color: rgb(0,0,0)"> FB_GetChineseSpell
(
</span><span style="color: rgb(0,128,0)">@Str</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">500</span><span style="color: rgb(0,0,0)">)</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">
)
</span><span style="color: rgb(0,0,255)">RETURNS</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">500</span><span style="color: rgb(0,0,0)">)
</span><span style="color: rgb(0,0,255)">as</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">begin</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">declare</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strLen</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">int</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">declare</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@index</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">int</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">declare</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">char</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(0,0,0)">)
</span><span style="color: rgb(0,0,255)">DECLARE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">VARCHAR</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">30</span><span style="color: rgb(0,0,0)">)
</span><span style="color: rgb(0,0,255)">declare</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@return</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">varchar</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(128,0,0); font-weight: bold">500</span><span style="color: rgb(0,0,0)">)
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@return</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">''</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@strlen</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,255)">len</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@str</span><span style="color: rgb(0,0,0)">)
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@index</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">while</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@index</span><span style="color: rgb(128,128,128)"><=</span><span style="color: rgb(0,128,0)">@strlen</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">begin</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,255)">substring</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@str</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(0,128,0)">@index</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">)
</span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">></span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">啊</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">芭</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">A</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">芭</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">擦</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">B</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">擦</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">搭</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">C</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">搭</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">娥</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">D</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">娥</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">发</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">E</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">发</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">嘎</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">F</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">></span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">嘎</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">哈</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">G</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">哈</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">击</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">H</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">击</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">喀</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">J</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">喀</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">垃</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">K</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">垃</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">妈</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">L</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">妈</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">拿</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">M</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">拿</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">哦</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">N</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">哦</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">啪</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">O</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">啪</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">期</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">P</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">期</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">然</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Q</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">然</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">撒</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">R</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">撒</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">塌</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">S</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">塌</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">挖</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">T</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">挖</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">昔</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">W</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">昔</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">压</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">X</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">压</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">匝</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Y</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">IF</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">匝</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">AND</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(128,128,128)"><=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">座</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">Z</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">ELSE</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,128,0)">@VChControl</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@return</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,128,0)">@return</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">RTRIM</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,255)">UPPER</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@VChSpell</span><span style="color: rgb(0,0,0)">))
</span><span style="color: rgb(0,0,255)">set</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,128,0)">@index</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,128,0)">@index</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,0,255)">return</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(0,128,0)">@return</span><span style="color: rgb(0,0,0)">) 
</span><span style="color: rgb(0,0,255)">end</span></div>
</div>
评论列表
本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。
试试其它关键字
　获取汉语拼音简码　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)