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

最新推荐文章于 2024-03-18 11:08:50 发布
最新推荐文章于 2024-03-18 11:08:50 发布
阅读量1.8k 收藏 9
点赞数 1
分类专栏： 数据库相关 文章标签： sql server 存储过程 汉子转拼音 Chinese English
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u010533180/article/details/77351617
版权

各位读者,请注意下面的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
转：sql server 中的汉字转化为拼音
总有一天，你的日积月累，会成为别人的望尘莫及
10-27 1563
原文转载自：http://www.cnblogs.com/for917157ever/archive/2012/05/24/2516057.html   转载内容如下： 在这里转化汉字有两种，一种是只取汉字的首字母，另一种是取汉字胡全拼, 1、只取汉字的首字母 代码如下： SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON go CRE...
sqlserver汉字转拼音(绝对的经典直接创建可用)
12-16
sqlserver汉字转拼音(绝对的经典直接创建可用)
抄一个汉字转汉语拼音缩写的存储过程
凤凰涅磐，做不老的程序员
04-02 150
If Exists (Select name From sysobjects Where name = 'HZToPY' And type = 'FN')Drop Function HZToPYGOCreate Function HZToPY(@HZ VarChar(50))Returns VarChar(50)AsBegin  Declare @PY VarChar(50),@LenHZ int...
存储过程汉字转拼音
iteye_15114的博客
07-10 175
存储过程汉字转拼音
Sqlserver得到汉字拼音首字母存储过程
jillcomputer的专栏
02-09 641
Sqlserver得到汉字拼音首字母存储过程: create function [dbo].[fun_getPY](@str nvarchar(4000))returns nvarchar(4000)asbegindeclare @word nchar(1),@PY nvarchar(4000)set @PY=while len(@str)>0begin   set @word=lef
sqlserver 汉字转拼音
aiyigeng5987的博客
01-04 453
作者不详 --方法一sqlserver汉字转拼音首字母 --调用方法 select dbo.procGetPY ('中國') Create FUNCTION dbo.procGetPY ( @str NVARCHAR(4000) ) /* select dbo. procGetPYFirstLetter ('中國') ...
SQLServer汉字转全拼音函数 .txt
10-31
### SQLServer中的汉字转全拼音函数 在数据库管理和数据处理领域，经常需要对文本进行各种形式的转换，以便于检索、排序或者分析等操作。其中一个常见的需求是将汉字转换为拼音，这对于支持中文环境的系统尤其重要...
sqlserver汉字转拼音
07-09
1：该存储过程，支持汉字转全拼和汉字转拼音首字母。 2:汉字转全拼已经经过优化 3：汉字转拼音首字母可以再sql server2000或以上版本使用。 4:汉字转全拼请在sql server 2005或以上版本使用。
sqlserver获取汉字的汉语拼音首字母支持多音字
01-04
首先，SQL Server本身并不直接支持汉字转拼音的功能，因此需要借助额外的函数或者自定义存储过程来实现。描述中的"Sql多音字处理V1.0.sql"很可能是一个包含了这种功能的自定义脚本，可能包含了一个或多个存储过程，...
利用SQL SERVER实现拼音简码自动转换汉字.pdf
09-19
为了解决这一难题，本文提出了一种利用SQL Server数据库排序规则的方法，通过编写自定义函数实现拼音简码到汉字的自动转换。这种方法的优势在于它极大地减轻了数据初始化的工作负担，同时保证了用户在操作上的便捷性...
SQL Server 汉字转拼音字母
weixin_34129145的博客
01-17 162
/* 汉字转拼音首字母 */ create function fun_getPY(@str nvarchar(4000)) returns nvarchar(4000) as begin declare @word nchar(1),@PY nvarchar(4000) set @PY='' while len(@str)>0 begin set @...
SQL Server汉字转首字母拼音
05-08
调用方法：select dbo.fn_GetSZMPY('我是汉字转首字母拼音方法') 调用方法：select dbo.fn_GetSZMPY('我是汉字转首字母拼音方法')
sql 汉字转拼音首字母代码
05-02
sql 汉字转拼音首字母 代码 function --汉字转拼音首字母sql Create FUNCTION dbo.fnpbGetPYFirstLetter ( @str NVARCHAR(4000) )
Microsoft SQL Server 编写汉字转拼音函数
最新发布
weixin_44837958的博客
03-18 467
在搜索应用中，我们一般会提供一个搜索框，输入关健字，点击查询按钮以获取结果数据。大部分情况我们会提供模糊查询的形式以在一个或多个字段进行搜索以获取结果。这样可以简化用户的操作，扩大搜索范围，为提高精度而提供基础范围数据。因此按汉字拼音搜索，即可以进一步简化输入，又可以进一步扩大搜索范围。
SQLSERVER中的汉字转拼音的实现
shazi
07-08 574
作者： shazi 教学过程中的一段代码： sql 代码 declare @strlen int,@return varchar(500),@ii int   declare @n int,@c char(1),@chn nchar(1),@str varchar(500)   set @str = '我爱伟大的周星驰'   select @strlen=le...
使用sql server的存储过程来讲中文汉字转化为拼音字符的代码实例教程
weixin_34008805的博客
07-27 387
中文汉字转化为拼音字符其实用的也不是很多，但是想在录入档案的时候可能就会用到这些信息，所以借此机会与大家一起分享一下通过数据库的存储过程和函数来实现的转化功能，希望对大家来说会有用！！！ IF OBJECT_ID('[fn_GetPinyin]') IS NOT NULL DROP FUNCTION [fn_GetPinyin] GO ...
SQL Server中实现汉字首字母和把汉字转成拼音的方法。
军哥博客欢迎您
07-25 4104
1 建表保存拼音、拼音首字母、和汉字的对照表。 脚本如下： CREATE TABLE [dbo].[SYS_ChinesePY](     [ID] [int] IDENTITY(1,1) NOT NULL,     [PYFIRST] [char](1) NULL,     [PYALL] [varchar](50) NULL,     [WORD] [nvarchar](1) NULL, ...
sqlserver 自定义函数汉字转拼音或首字母
阿涩的博客
09-02 2003
执行下面sql 就自定义函数了View CodegoASBEGINset @PY=''BEGIN--如果非汉字字符，返回原字符then (fromselect 'A' as PY,N'驁' as wordunion all select 'B',N'簿'union all select 'C',N'錯'union all select 'D',N'鵽'union all select 'E',N'樲'union all select 'F',N'鰒'
sqlserver 2008R2 汉字转拼音问题
qq_35515012的博客
01-29 216
sqlserver 2008 R2 排序规则为SQL_Latin1_General_CP1_CI_AS 实现汉字转拼音 汉字转拼音（仅首字母） -- SELECT dbo.fnGetPinInitials(N'你好') IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[fnGetPinInitials]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值