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

最新推荐文章于 2024-03-11 11:18:36 发布
最新推荐文章于 2024-03-11 11:18:36 发布
阅读量1.7k 收藏 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
菜鸟葫芦娃
关注
  • 1
    点赞
  • 踩
  • 9
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
sqlserver汉字转拼音
07-09
1：该存储过程，支持汉字转全拼和汉字转拼音首字母。 2:汉字转全拼已经经过优化 3：汉字转拼音首字母可以再sql server2000或以上版本使用。 4:汉字转全拼请在sql server 2005或以上版本使用。
SqlServer数据库中文乱码问题解决方法
Alex的博客
04-30 8874
这个问题在网上找了很多资料都没找到真正解决问题的办法，最终去了官网，终于找到问题的答案了，整理出来做个记录。问题描述：项目中遇到一个问题，sqlserver中的数据是ok的，结果保存到mysql中是乱码，在确认mysql没问题的情况下开始处理sqlserver的编码。
解决SqlServer无法查询中文的问题
qq_41700921的博客
04-04 3400
[失败] select * from COURSE where CNAME= '数学'; [成功] select * from COURSEwhere CNAME= N'数学';
Microsoft SQL Server 编写汉字转拼音函数
最新发布
初九之潜龙勿用
03-11 3970
在搜索应用中，我们一般会提供一个搜索框，输入关健字，点击查询按钮以获取结果数据。大部分情况我们会提供模糊查询的形式以在一个或多个字段进行搜索以获取结果。这样可以简化用户的操作，扩大搜索范围，为提高精度而提供基础范围数据。因此按汉字拼音搜索，即可以进一步简化输入，又可以进一步扩大搜索范围。
SQLServer 将文字转换成拼音首字母方法
Zhou_zichao的博客
08-29 380
【代码】SQLServer 将文字转换成拼音首字母方法。
SQL Server 2000 汉字数据简繁转换实例 (COM,.Net)
playyuer㊣www.Microshaoft.com I Love UltraEditPlus
07-30 5228
SQL Server 2000 汉字数据简繁转换实例 (COM,.Net)首先确认在 Windows (当然只是 SQL Server 的服务器端) 上安装了 .Net Framework 1.1 !确认成功安装后:1.用 sn -k 为该类库创建一个强名密钥文件:  在安装 Microsoft .Net Framework SDK 的所在目录下的 v1.1/Bin/ 子目录下执行如下命令
sqlserver简体繁体字转换
wvivw的专栏
08-24 452
一直没找到这个样的数据，好多地方简繁对照数据都要钱还不知道有多少条数据， 然后自己整理了一下 常用汉字简体繁体对照表Excel表格2281条数据 可以用于sqlserver数据库的简繁转化
SQL server中使用存储过程
yeliner的博客
04-15 2712
一.存储过程(stored procedure) 为了完成一定功能的一组sql语句 经过编译后存储到数据库 系统存储过程_sp, 拓展存储过程_xp, 用户自定义存储过程_usp 二.优点(为什么要用存储过程) ①模块化编程 ②减少网络的流量 ③提高执行速度 ④提高数据的安全性 三.创建使用 1.创建语句 create pr...
存储过程：数据的插入和更新
weixin_34191734的博客
08-10 1667
    存储过程的功能非常强大，在某种程度上甚至可以替代业务逻辑层， 接下来就一个小例子来说明，用存储过程插入或更新语句。 1、数据库表结构     所用数据库为Sql Server2008。 2、创建存储过程 （1）实现功能：1）有相同的数据，直接返回（返回值：0）； 　　　　　　 2）有主键相同，但是数据不同的数据，进行更新处理（返回值：2）； 　　　　　　 3）没有数据，进...
一个SQL数据库简体繁体数据转换问题
01-13 602
昨天晚上公司为了一客户，在软件上可以实现简体转为繁体，但有些数据库的数据为能自动转换，得手工转换。找了半天的资料，一直未能找到一个可以转换SQL数据库的字体从简体为繁体。后来想到一个使用ACCESS链接SQL数据库，再通过复制到...
sqlserver汉字转拼音(绝对的经典直接创建可用)
12-16
sqlserver汉字转拼音(绝对的经典直接创建可用)
sql,C#汉字转拼音首字母
01-06
sqlserver 存储过程转拼音首字母 C#转拼音首字母和全拼
KTV.rar_KTV_sql server做ktv
09-23
用c#和SqlServer2005做的卡拉OK点歌系统， 系统主要实现以下目标： &#61548 系统采用人机交互的方式，界面美观友好，信息查询灵活、方便，数据存储安全可靠。 &#61548 歌星点歌，根据演唱歌星的名字来查询选择歌曲...
SQL Server 聚集索引和非聚集索引的区别分析
12-15
比如，我们要查“安”字，就会很自然地翻开字典的前几页，因为“安”的拼音是“an”，而按照拼音排序汉字的字典是以英文字母“a”开头并以“z”结尾的，那么“安”字就自然地排在字典的前部。如果您翻完了所有以“a...
SQLSERVER 创建索引实现代码
01-19
什么是索引 拿汉语字典的目录页（索引）打比方：正如汉语字典中的汉字按页存放一样，SQL Server中的数据记录也是按页存放的，每页容量一般为4K。为了加快查找的速度，汉语字（词）典一般都有按拼音、笔画、偏旁部首...
SQL SERVER 查询作业（Job）基本信息及执行情况的sql
热门推荐
菜鸟葫芦娃
08-12 1万+
SQL SERVER 查询作业（Job）基本信息及执行情况的sql
数据库视图中嵌套视图的注意事项----知识点 ----有点狂
菜鸟葫芦娃
03-29 6653
数据库视图中嵌套视图的注意事项
SqlServer 中所有表、列、视图、索引、主键、外键等常用sql
菜鸟葫芦娃
04-24 3445
SqlServer 中所有表、列、视图、索引、主键、外键等常用sql
sqlserver转mysql 存储过程 转换
07-20
将 SQL Server 的存储过程转换为 MySQL 的存储过程可以分为以下几个步骤： 1. 语法转换：SQL Server 和 MySQL 在存储过程语法上存在一些差异，需要将 SQL Server 的语法转换为 MySQL 的语法。例如，将 `@@ROWCOUNT`...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值