SqlServer高效汉字转拼音的存储过程

各位读者,请注意下面的Sql语句中的汉子不是乱码、不是乱码、不是乱码,是每个汉字对应最大的ascii码,因为中文比较大小是按照ascii码进行比对的,根据这个原理写出的如下存储过程,另外不知道汉子组合原理的小伙伴,自行查询规则。如果下面缺失了对应的汉字,请在评论区下方留言,我们一起进步,谢谢！共造和谐技术氛围。

/****** Object: StoredProcedure [dbo].[ConvertChineseToEnglish] ******/

CREATE PROC [dbo].[ConvertChineseToEnglish]
    @chineseStr VARCHAR(100) ,
    @res VARCHAR(8000) OUTPUT
AS
    BEGIN
        DECLARE @tmpStr VARCHAR(10);
        DECLARE @strlen INT; 
SELECT  @strlen = LEN(@chineseStr);
SET @res = '';
        WHILE @strlen > 0
            BEGIN  
SET @tmpStr = SUBSTRING(@chineseStr, @strlen, 1);
SELECT  @res = CASE WHEN @tmpStr < '吖' THEN @tmpStr
WHEN @tmpStr <= '厑' THEN 'a'
WHEN @tmpStr <= '靉' THEN 'ai'
WHEN @tmpStr <= '黯' THEN 'an'
WHEN @tmpStr <= '醠' THEN 'ang'
WHEN @tmpStr <= '驁' THEN 'ao'
WHEN @tmpStr <= '欛' THEN 'ba'
WHEN @tmpStr <= '瓸' THEN 'bai'
WHEN @tmpStr <= '瓣' THEN 'ban'
WHEN @tmpStr <= '鎊' THEN 'bang'
WHEN @tmpStr <= '鑤' THEN 'bao'
WHEN @tmpStr <= '鐾' THEN 'bei'
WHEN @tmpStr <= '輽' THEN 'ben'
WHEN @tmpStr <= '鏰' THEN 'beng'
WHEN @tmpStr <= '鼊' THEN 'bi'
WHEN @tmpStr <= '變' THEN 'bian'
WHEN @tmpStr <= '鰾' THEN 'biao'
WHEN @tmpStr <= '彆' THEN 'bie'
WHEN @tmpStr <= '鬢' THEN 'bin'
WHEN @tmpStr <= '靐' THEN 'bing'
WHEN @tmpStr <= '蔔' THEN 'bo'
WHEN @tmpStr <= '簿' THEN 'bu'
WHEN @tmpStr <= '囃' THEN 'ca'
WHEN @tmpStr <= '乲' THEN 'cai'
WHEN @tmpStr <= '爘' THEN 'can'
WHEN @tmpStr <= '賶' THEN 'cang'
WHEN @tmpStr <= '鼜' THEN 'cao'
WHEN @tmpStr <= '簎' THEN 'ce'
WHEN @tmpStr <= '笒' THEN 'cen'
WHEN @tmpStr <= '乽' THEN 'ceng'
WHEN @tmpStr <= '詫' THEN 'cha'
WHEN @tmpStr <= '囆' THEN 'chai'
WHEN @tmpStr <= '顫' THEN 'chan'
WHEN @tmpStr <= '韔' THEN 'chang'
WHEN @tmpStr <= '觘' THEN 'chao'
WHEN @tmpStr <= '爡' THEN 'che'
WHEN @tmpStr <= '讖' THEN 'chen'
WHEN @tmpStr <= '秤' THEN 'cheng'
WHEN @tmpStr <= '鷘' THEN 'chi'
WHEN @tmpStr <= '銃' THEN 'chong'
WHEN @tmpStr <= '殠' THEN 'chou'
WHEN @tmpStr <= '矗' THEN 'chu'
WHEN @tmpStr <= '踹' THEN 'chuai'
WHEN @tmpStr <= '鶨' THEN 'chuan'
WHEN @tmpStr <= '愴' THEN 'chuang'
WHEN @tmpStr <= '顀' THEN 'chui'
WHEN @tmpStr <= '蠢' THEN 'chun'
WHEN @tmpStr <= '縒' THEN 'chuo'
WHEN @tmpStr <= '嗭' THEN 'ci'
WHEN @tmpStr <= '謥' THEN 'cong'
WHEN @tmpStr <= '輳' THEN 'cou'
WHEN @tmpStr <= '顣' THEN 'cu'
WHEN @tmpStr <= '爨' THEN 'cuan'
WHEN @tmpStr <= '臎' THEN 'cui'
WHEN @tmpStr <= '籿' THEN 'cun'
WHEN @tmpStr <= '錯' THEN 'cuo'
WHEN @tmpStr <= '橽' THEN 'da'
WHEN @tmpStr <= '靆' THEN 'dai'
WHEN @tmpStr <= '饏' THEN 'dan'
WHEN @tmpStr <= '闣' THEN 'dang'
WHEN @tmpStr <= '纛' THEN 'dao'
WHEN @tmpStr <= '的' THEN 'de'
WHEN @tmpStr <= '扽' THEN 'den'
WHEN @tmpStr <= '鐙' THEN 'deng'
WHEN @tmpStr <= '螮' THEN 'di'
WHEN @tmpStr <= '嗲' THEN 'dia'
WHEN @tmpStr <= '驔' THEN 'dian'
WHEN @tmpStr <= '鑃' THEN 'diao'
WHEN @tmpStr <= '嚸' THEN 'die'
WHEN @tmpStr <= '顁' THEN 'ding'
WHEN @tmpStr <= '銩' THEN 'diu'
WHEN @tmpStr <= '霘' THEN 'dong'
WHEN @tmpStr <= '鬭' THEN 'dou'
WHEN @tmpStr <= '蠹' THEN 'du'
WHEN @tmpStr <= '叾' THEN 'duan'
WHEN @tmpStr <= '譵' THEN 'dui'
WHEN @tmpStr <= '踲' THEN 'dun'
WHEN @tmpStr <= '鵽' THEN 'duo'
WHEN @tmpStr <= '鱷' THEN 'e'
WHEN @tmpStr <= '摁' THEN 'en'
WHEN @tmpStr <= '鞥' THEN 'eng'
WHEN @tmpStr <= '樲' THEN 'er'
WHEN @tmpStr <= '髮' THEN 'fa'
WHEN @tmpStr <= '瀪' THEN 'fan'
WHEN @tmpStr <= '放' THEN 'fang'
WHEN @tmpStr <= '靅' THEN 'fei'
WHEN @tmpStr <= '鱝' THEN 'fen'
WHEN @tmpStr <= '覅' THEN 'feng'
WHEN @tmpStr <= '梻' THEN 'fo'
WHEN @tmpStr <= '鴀' THEN 'fou'
WHEN @tmpStr <= '猤' THEN 'fu'
WHEN @tmpStr <= '魀' THEN 'ga'
WHEN @tmpStr <= '瓂' THEN 'gai'
WHEN @tmpStr <= '灨' THEN 'gan'
WHEN @tmpStr <= '戇' THEN 'gang'
WHEN @tmpStr <= '鋯' THEN 'gao'
WHEN @tmpStr <= '獦' THEN 'ge'
WHEN @tmpStr <= '給' THEN 'gei'
WHEN @tmpStr <= '搄' THEN 'gen'
WHEN @tmpStr <= '堩' THEN 'geng'
WHEN @tmpStr <= '兣' THEN 'gong'
WHEN @tmpStr <= '購' THEN 'gou'
WHEN @tmpStr <= '顧' THEN 'gu'
WHEN @tmpStr <= '詿' THEN 'gua'
WHEN @tmpStr <= '恠' THEN 'guai'
WHEN @tmpStr <= '鱹' THEN 'guan'
WHEN @tmpStr <= '撗' THEN 'guang'
WHEN @tmpStr <= '鱥' THEN 'gui'
WHEN @tmpStr <= '謴' THEN 'gun'
WHEN @tmpStr <= '腂' THEN 'guo'
WHEN @tmpStr <= '哈' THEN 'ha'
WHEN @tmpStr <= '饚' THEN 'hai'
WHEN @tmpStr <= '鶾' THEN 'han'
WHEN @tmpStr <= '沆' THEN 'hang'
WHEN @tmpStr <= '兞' THEN 'hao'
WHEN @tmpStr <= '靏' THEN 'he'
WHEN @tmpStr <= '嬒' THEN 'hei'
WHEN @tmpStr <= '恨' THEN 'hen'
WHEN @tmpStr <= '堼' THEN 'heng'
WHEN @tmpStr <= '鬨' THEN 'hong'
WHEN @tmpStr <= '*' THEN 'hou'
WHEN @tmpStr <= '*' THEN 'hu'
WHEN @tmpStr <= '蘳' THEN 'hua'
WHEN @tmpStr <= '蘾' THEN 'huai'
WHEN @tmpStr <= '鰀' THEN 'huan'
WHEN @tmpStr <= '鎤' THEN 'huang'
WHEN @tmpStr <= '顪' THEN 'hui'
WHEN @tmpStr <= '諢' THEN 'hun'
WHEN @tmpStr <= '夻' THEN 'huo'
WHEN @tmpStr <= '驥' THEN 'ji'
WHEN @tmpStr <= '嗧' THEN 'jia'
WHEN @tmpStr <= '鑳' THEN 'jian'
WHEN @tmpStr <= '謽' THEN 'jiang'
WHEN @tmpStr <= '釂' THEN 'jiao'
WHEN @tmpStr <= '繲' THEN 'jie'
WHEN @tmpStr <= '齽' THEN 'jin'
WHEN @tmpStr <= '竸' THEN 'jing'
WHEN @tmpStr <= '蘔' THEN 'jiong'
WHEN @tmpStr <= '欍' THEN 'jiu'
WHEN @tmpStr <= '爠' THEN 'ju'
WHEN @tmpStr <= '羂' THEN 'juan'
WHEN @tmpStr <= '钁' THEN 'jue'
WHEN @tmpStr <= '攈' THEN 'jun'
WHEN @tmpStr <= '鉲' THEN 'ka'
WHEN @tmpStr <= '乫' THEN 'kai'
WHEN @tmpStr <= '矙' THEN 'kan'
WHEN @tmpStr <= '閌' THEN 'kang'
WHEN @tmpStr <= '鯌' THEN 'kao'
WHEN @tmpStr <= '騍' THEN 'ke'
WHEN @tmpStr <= '褃' THEN 'ken'
WHEN @tmpStr <= '鏗' THEN 'keng'
WHEN @tmpStr <= '廤' THEN 'kong'
WHEN @tmpStr <= '鷇' THEN 'kou'
WHEN @tmpStr <= '嚳' THEN 'ku'
WHEN @tmpStr <= '骻' THEN 'kua'
WHEN @tmpStr <= '鱠' THEN 'kuai'
WHEN @tmpStr <= '窾' THEN 'kuan'
WHEN @tmpStr <= '鑛' THEN 'kuang'
WHEN @tmpStr <= '鑎' THEN 'kui'
WHEN @tmpStr <= '睏' THEN 'kun'
WHEN @tmpStr <= '穒' THEN 'kuo'
WHEN @tmpStr <= '鞡' THEN 'la'
WHEN @tmpStr <= '籟' THEN 'lai'
WHEN @tmpStr <= '糷' THEN 'lan'
WHEN @tmpStr <= '唥' THEN 'lang'
WHEN @tmpStr <= '軂' THEN 'lao'
WHEN @tmpStr <= '餎' THEN 'le'
WHEN @tmpStr <= '脷' THEN 'lei'
WHEN @tmpStr <= '睖' THEN 'leng'
WHEN @tmpStr <= '瓈' THEN 'li'
WHEN @tmpStr <= '倆' THEN 'lia'
WHEN @tmpStr <= '纞' THEN 'lian'
WHEN @tmpStr <= '鍄' THEN 'liang'
WHEN @tmpStr <= '瞭' THEN 'liao'
WHEN @tmpStr <= '鱲' THEN 'lie'
WHEN @tmpStr <= '轥' THEN 'lin'
WHEN @tmpStr <= '炩' THEN 'ling'
WHEN @tmpStr <= '咯' THEN 'liu'
WHEN @tmpStr <= '贚' THEN 'long'
WHEN @tmpStr <= '鏤' THEN 'lou'
WHEN @tmpStr <= '氇' THEN 'lu'
WHEN @tmpStr <= '鑢' THEN 'lv'
WHEN @tmpStr <= '亂' THEN 'luan'
WHEN @tmpStr <= '擽' THEN 'lue'
WHEN @tmpStr <= '論' THEN 'lun'
WHEN @tmpStr <= '鱳' THEN 'luo'
WHEN @tmpStr <= '嘛' THEN 'ma'
WHEN @tmpStr <= '霢' THEN 'mai'
WHEN @tmpStr <= '蘰' THEN 'man'
WHEN @tmpStr <= '蠎' THEN 'mang'
WHEN @tmpStr <= '唜' THEN 'mao'
WHEN @tmpStr <= '癦' THEN 'me'
WHEN @tmpStr <= '嚜' THEN 'mei'
WHEN @tmpStr <= '們' THEN 'men'
WHEN @tmpStr <= '霥' THEN 'meng'
WHEN @tmpStr <= '羃' THEN 'mi'
WHEN @tmpStr <= '麵' THEN 'mian'
WHEN @tmpStr <= '廟' THEN 'miao'
WHEN @tmpStr <= '鱴' THEN 'mie'
WHEN @tmpStr <= '鰵' THEN 'min'
WHEN @tmpStr <= '詺' THEN 'ming'
WHEN @tmpStr <= '謬' THEN 'miu'
WHEN @tmpStr <= '耱' THEN 'mo'
WHEN @tmpStr <= '麰' THEN 'mou'
WHEN @tmpStr <= '旀' THEN 'mu'
WHEN @tmpStr <= '魶' THEN 'na'
WHEN @tmpStr <= '錼' THEN 'nai'
WHEN @tmpStr <= '婻' THEN 'nan'
WHEN @tmpStr <= '齉' THEN 'nang'
WHEN @tmpStr <= '臑' THEN 'nao'
WHEN @tmpStr <= '呢' THEN 'ne'
WHEN @tmpStr <= '焾' THEN 'nei'
WHEN @tmpStr <= '嫩' THEN 'nen'
WHEN @tmpStr <= '能' THEN 'neng'
WHEN @tmpStr <= '嬺' THEN 'ni'
WHEN @tmpStr <= '艌' THEN 'nian'
WHEN @tmpStr <= '釀' THEN 'niang'
WHEN @tmpStr <= '脲' THEN 'niao'
WHEN @tmpStr <= '钀' THEN 'nie'
WHEN @tmpStr <= '拰' THEN 'nin'
WHEN @tmpStr <= '濘' THEN 'ning'
WHEN @tmpStr <= '靵' THEN 'niu'
WHEN @tmpStr <= '齈' THEN 'nong'
WHEN @tmpStr <= '譳' THEN 'nou'
WHEN @tmpStr <= '搙' THEN 'nu'
WHEN @tmpStr <= '衄' THEN 'nv'
WHEN @tmpStr <= '瘧' THEN 'nue'
WHEN @tmpStr <= '燶' THEN 'nuan'
WHEN @tmpStr <= '桛' THEN 'nuo'
WHEN @tmpStr <= '鞰' THEN 'o'
WHEN @tmpStr <= '漚' THEN 'ou'
WHEN @tmpStr <= '袙' THEN 'pa'
WHEN @tmpStr <= '磗' THEN 'pai'
WHEN @tmpStr <= '鑻' THEN 'pan'
WHEN @tmpStr <= '胖' THEN 'pang'
WHEN @tmpStr <= '礮' THEN 'pao'
WHEN @tmpStr <= '轡' THEN 'pei'
WHEN @tmpStr <= '喯' THEN 'pen'
WHEN @tmpStr <= '喸' THEN 'peng'
WHEN @tmpStr <= '鸊' THEN 'pi'
WHEN @tmpStr <= '騙' THEN 'pian'
WHEN @tmpStr <= '慓' THEN 'piao'
WHEN @tmpStr <= '嫳' THEN 'pie'
WHEN @tmpStr <= '聘' THEN 'pin'
WHEN @tmpStr <= '蘋' THEN 'ping'
WHEN @tmpStr <= '魄' THEN 'po'
WHEN @tmpStr <= '哛' THEN 'pou'
WHEN @tmpStr <= '曝' THEN 'pu'
WHEN @tmpStr <= '蟿' THEN 'qi'
WHEN @tmpStr <= '髂' THEN 'qia'
WHEN @tmpStr <= '縴' THEN 'qian'
WHEN @tmpStr <= '瓩' THEN 'qiang'
WHEN @tmpStr <= '躈' THEN 'qiao'
WHEN @tmpStr <= '籡' THEN 'qie'
WHEN @tmpStr <= '藽' THEN 'qin'
WHEN @tmpStr <= '櫦' THEN 'qing'
WHEN @tmpStr <= '瓗' THEN 'qiong'
WHEN @tmpStr <= '糗' THEN 'qiu'
WHEN @tmpStr <= '覻' THEN 'qu'
WHEN @tmpStr <= '勸' THEN 'quan'
WHEN @tmpStr <= '礭' THEN 'que'
WHEN @tmpStr <= '囕' THEN 'qun'
WHEN @tmpStr <= '橪' THEN 'ran'
WHEN @tmpStr <= '讓' THEN 'rang'
WHEN @tmpStr <= '繞' THEN 'rao'
WHEN @tmpStr <= '熱' THEN 're'
WHEN @tmpStr <= '餁' THEN 'ren'
WHEN @tmpStr <= '陾' THEN 'reng'
WHEN @tmpStr <= '馹' THEN 'ri'
WHEN @tmpStr <= '穃' THEN 'rong'
WHEN @tmpStr <= '嶿' THEN 'rou'
WHEN @tmpStr <= '擩' THEN 'ru'
WHEN @tmpStr <= '礝' THEN 'ruan'
WHEN @tmpStr <= '壡' THEN 'rui'
WHEN @tmpStr <= '橍' THEN 'run'
WHEN @tmpStr <= '鶸' THEN 'ruo'
WHEN @tmpStr <= '栍' THEN 'sa'
WHEN @tmpStr <= '虄' THEN 'sai'
WHEN @tmpStr <= '閐' THEN 'san'
WHEN @tmpStr <= '喪' THEN 'sang'
WHEN @tmpStr <= '髞' THEN 'sao'
WHEN @tmpStr <= '飋' THEN 'se'
WHEN @tmpStr <= '篸' THEN 'sen'
WHEN @tmpStr <= '縇' THEN 'seng'
WHEN @tmpStr <= '霎' THEN 'sha'
WHEN @tmpStr <= '曬' THEN 'shai'
WHEN @tmpStr <= '鱔' THEN 'shan'
WHEN @tmpStr <= '緔' THEN 'shang'
WHEN @tmpStr <= '潲' THEN 'shao'
WHEN @tmpStr <= '欇' THEN 'she'
WHEN @tmpStr <= '瘮' THEN 'shen'
WHEN @tmpStr <= '賸' THEN 'sheng'
WHEN @tmpStr <= '瓧' THEN 'shi'
WHEN @tmpStr <= '鏉' THEN 'shou'
WHEN @tmpStr <= '虪' THEN 'shu'
WHEN @tmpStr <= '誜' THEN 'shua'
WHEN @tmpStr <= '卛' THEN 'shuai'
WHEN @tmpStr <= '腨' THEN 'shuan'
WHEN @tmpStr <= '灀' THEN 'shuang'
WHEN @tmpStr <= '睡' THEN 'shui'
WHEN @tmpStr <= '鬊' THEN 'shun'
WHEN @tmpStr <= '鑠' THEN 'shuo'
WHEN @tmpStr <= '乺' THEN 'si'
WHEN @tmpStr <= '鎹' THEN 'song'
WHEN @tmpStr <= '瘶' THEN 'sou'
WHEN @tmpStr <= '鷫' THEN 'su'
WHEN @tmpStr <= '算' THEN 'suan'
WHEN @tmpStr <= '鐩' THEN 'sui'
WHEN @tmpStr <= '潠' THEN 'sun'
WHEN @tmpStr <= '蜶' THEN 'suo'
WHEN @tmpStr <= '襨' THEN 'ta'
WHEN @tmpStr <= '燤' THEN 'tai'
WHEN @tmpStr <= '賧' THEN 'tan'
WHEN @tmpStr <= '燙' THEN 'tang'
WHEN @tmpStr <= '畓' THEN 'tao'
WHEN @tmpStr <= '蟘' THEN 'te'
WHEN @tmpStr <= '朰' THEN 'teng'
WHEN @tmpStr <= '趯' THEN 'ti'
WHEN @tmpStr <= '舚' THEN 'tian'
WHEN @tmpStr <= '糶' THEN 'tiao'
WHEN @tmpStr <= '餮' THEN 'tie'
WHEN @tmpStr <= '乭' THEN 'ting'
WHEN @tmpStr <= '憅' THEN 'tong'
WHEN @tmpStr <= '透' THEN 'tou'
WHEN @tmpStr <= '鵵' THEN 'tu'
WHEN @tmpStr <= '褖' THEN 'tuan'
WHEN @tmpStr <= '駾' THEN 'tui'
WHEN @tmpStr <= '坉' THEN 'tun'
WHEN @tmpStr <= '籜' THEN 'tuo'
WHEN @tmpStr <= '韤' THEN 'wa'
WHEN @tmpStr <= '顡' THEN 'wai'
WHEN @tmpStr <= '贎' THEN 'wan'
WHEN @tmpStr <= '朢' THEN 'wang'
WHEN @tmpStr <= '躛' THEN 'wei'
WHEN @tmpStr <= '璺' THEN 'wen'
WHEN @tmpStr <= '齆' THEN 'weng'
WHEN @tmpStr <= '齷' THEN 'wo'
WHEN @tmpStr <= '鶩' THEN 'wu'
WHEN @tmpStr <= '衋' THEN 'xi'
WHEN @tmpStr <= '鏬' THEN 'xia'
WHEN @tmpStr <= '鼸' THEN 'xian'
WHEN @tmpStr <= '鱌' THEN 'xiang'
WHEN @tmpStr <= '斆' THEN 'xiao'
WHEN @tmpStr <= '躞' THEN 'xie'
WHEN @tmpStr <= '釁' THEN 'xin'
WHEN @tmpStr <= '臖' THEN 'xing'
WHEN @tmpStr <= '敻' THEN 'xiong'
WHEN @tmpStr <= '齅' THEN 'xiu'
WHEN @tmpStr <= '蓿' THEN 'xu'
WHEN @tmpStr <= '贙' THEN 'xuan'
WHEN @tmpStr <= '瀥' THEN 'xue'
WHEN @tmpStr <= '鑂' THEN 'xun'
WHEN @tmpStr <= '齾' THEN 'ya'
WHEN @tmpStr <= '灩' THEN 'yan'
WHEN @tmpStr <= '樣' THEN 'yang'
WHEN @tmpStr <= '鑰' THEN 'yao'
WHEN @tmpStr <= '岃' THEN 'ye'
WHEN @tmpStr <= '齸' THEN 'yi'
WHEN @tmpStr <= '檼' THEN 'yin'
WHEN @tmpStr <= '譍' THEN 'ying'
WHEN @tmpStr <= '喲' THEN 'yo'
WHEN @tmpStr <= '醟' THEN 'yong'
WHEN @tmpStr <= '鼬' THEN 'you'
WHEN @tmpStr <= '爩' THEN 'yu'
WHEN @tmpStr <= '願' THEN 'yuan'
WHEN @tmpStr <= '鸙' THEN 'yue'
WHEN @tmpStr <= '韻' THEN 'yun'
WHEN @tmpStr <= '雥' THEN 'za'
WHEN @tmpStr <= '縡' THEN 'zai'
WHEN @tmpStr <= '饡' THEN 'zan'
WHEN @tmpStr <= '臟' THEN 'zang'
WHEN @tmpStr <= '竈' THEN 'zao'
WHEN @tmpStr <= '稄' THEN 'ze'
WHEN @tmpStr <= '鱡' THEN 'zei'
WHEN @tmpStr <= '囎' THEN 'zen'
WHEN @tmpStr <= '贈' THEN 'zeng'
WHEN @tmpStr <= '醡' THEN 'zha'
WHEN @tmpStr <= '瘵' THEN 'zhai'
WHEN @tmpStr <= '驏' THEN 'zhan'
WHEN @tmpStr <= '瞕' THEN 'zhang'
WHEN @tmpStr <= '羄' THEN 'zhao'
WHEN @tmpStr <= '鷓' THEN 'zhe'
WHEN @tmpStr <= '黮' THEN 'zhen'
WHEN @tmpStr <= '證' THEN 'zheng'
WHEN @tmpStr <= '豒' THEN 'zhi'
WHEN @tmpStr <= '諥' THEN 'zhong'
WHEN @tmpStr <= '驟' THEN 'zhou'
WHEN @tmpStr <= '鑄' THEN 'zhu'
WHEN @tmpStr <= '爪' THEN 'zhua'
WHEN @tmpStr <= '跩' THEN 'zhuai'
WHEN @tmpStr <= '籑' THEN 'zhuan'
WHEN @tmpStr <= '戅' THEN 'zhuang'
WHEN @tmpStr <= '鑆' THEN 'zhui'
WHEN @tmpStr <= '稕' THEN 'zhun'
WHEN @tmpStr <= '籱' THEN 'zhuo'
WHEN @tmpStr <= '漬' THEN 'zi'
WHEN @tmpStr <= '縱' THEN 'zong'
WHEN @tmpStr <= '媰' THEN 'zou'
WHEN @tmpStr <= '謯' THEN 'zu'
WHEN @tmpStr <= '攥' THEN 'zuan'
WHEN @tmpStr <= '欈' THEN 'zui'
WHEN @tmpStr <= '銌' THEN 'zun'
WHEN @tmpStr <= '咗' THEN 'zuo'
ELSE @tmpStr
END + @res ,
                        @strlen = @strlen - 1; 
END;
END;


GO