SQLServer汉字转全拼音函数

概述SQLServer汉字转全拼音函数

下面是内存溢出 jb51.cc 通过网络收集整理的代码片段。

内存溢出小编现在分享给大家，也给大家做个参考。

    USE Test      go            IF OBJECT_ID('Fn_GetQuanPin','Fn') IS NOT NulL          DROP FUNCTION fn_GetQuanPin      go            create function [dbo].[fn_GetQuanPin](@str varchar(100))      returns varchar(8000)      as      begin       declare @re varchar(8000),@crs varchar(10)       declare @strlen int        select @strlen=len(@str),@re=''       while @strlen>0       begin          set @crs= substring(@str,@strlen,1)            select @re=              CASE               when @crs<'吖' ColLATE Chinese_PRC_CS_AS_KS_WS then @crs              when @crs<='厑' ColLATE Chinese_PRC_CS_AS_KS_WS then 'A'              when @crs<='靉' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ai'              when @crs<='黯' ColLATE Chinese_PRC_CS_AS_KS_WS then 'An'              when @crs<='醠' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ang'              when @crs<='驁' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ao'              when @crs<='欛' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ba'              when @crs<='瓸' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Bai'              when @crs<='瓣' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ban'              when @crs<='鎊' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Bang'              when @crs<='鑤' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Bao'              when @crs<='鐾' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Bei'              when @crs<='輽' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ben'              when @crs<='鏰' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Beng'              when @crs<='鼊' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Bi'              when @crs<='變' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Bian'              when @crs<='鰾' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Biao'              when @crs<='彆' ColLATE Chinese_PRC_CS_AS_KS_WS then 'BIE'              when @crs<='鬢' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Bin'              when @crs<='靐' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Bing'              when @crs<='蔔' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Bo'              when @crs<='簿' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Bu'              when @crs<='囃' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ca'              when @crs<='乲' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cai'              when @crs<='爘' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Can'              when @crs<='賶' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cang'              when @crs<='鼜' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cao'              when @crs<='簎' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ce'              when @crs<='笒' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cen'              when @crs<='乽' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ceng'              when @crs<='詫' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cha'              when @crs<='囆' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chai'              when @crs<='顫' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chan'              when @crs<='韔' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chang'              when @crs<='觘' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chao'              when @crs<='爡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Che'              when @crs<='讖' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chen'              when @crs<='秤' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cheng'              when @crs<='鷘' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chi'              when @crs<='銃' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chong'              when @crs<='殠' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chou'              when @crs<='矗' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chu'              when @crs<='踹' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chuai'              when @crs<='鶨' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chuan'              when @crs<='愴' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chuang'              when @crs<='顀' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chui'              when @crs<='蠢' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chun'              when @crs<='縒' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Chuo'              when @crs<='嗭' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ci'              when @crs<='謥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cong'              when @crs<='輳' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cou'              when @crs<='顣' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cu'              when @crs<='爨' ColLATE Chinese_PRC_CS_AS_KS_WS then 'cuan'              when @crs<='臎' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cui'              when @crs<='籿' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cun'              when @crs<='錯' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Cuo'              when @crs<='橽' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Da'              when @crs<='靆' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Dai'              when @crs<='饏' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Dan'              when @crs<='闣' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Dang'              when @crs<='纛' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Dao'              when @crs<='的' ColLATE Chinese_PRC_CS_AS_KS_WS then 'De'              when @crs<='扽' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Den'              when @crs<='鐙' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Deng'              when @crs<='螮' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Di'              when @crs<='嗲' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Dia'              when @crs<='驔' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Dian'              when @crs<='鑃' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Diao'              when @crs<='嚸' ColLATE Chinese_PRC_CS_AS_KS_WS then 'DIE'              when @crs<='顁' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ding'              when @crs<='銩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Diu'              when @crs<='霘' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Dong'              when @crs<='鬭' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Dou'              when @crs<='蠹' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Du'              when @crs<='叾' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Duan'              when @crs<='譵' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Dui'              when @crs<='踲' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Dun'              when @crs<='鵽' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Duo'              when @crs<='鱷' ColLATE Chinese_PRC_CS_AS_KS_WS then 'E'              when @crs<='摁' ColLATE Chinese_PRC_CS_AS_KS_WS then 'En'              when @crs<='鞥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Eng'              when @crs<='樲' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Er'              when @crs<='髮' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Fa'              when @crs<='瀪' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Fan'              when @crs<='放' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Fang'              when @crs<='靅' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Fei'              when @crs<='鱝' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Fen'              when @crs<='覅' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Feng'              when @crs<='梻' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Fo'              when @crs<='鴀' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Fou'              when @crs<='猤' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Fu'              when @crs<='魀' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ga'              when @crs<='瓂' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gai'              when @crs<='灨' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gan'              when @crs<='戇' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gang'              when @crs<='鋯' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gao'              when @crs<='獦' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ge'              when @crs<='給' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gei'              when @crs<='搄' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gen'              when @crs<='堩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Geng'              when @crs<='兣' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gong'              when @crs<='購' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gou'              when @crs<='顧' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gu'              when @crs<='詿' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gua'              when @crs<='恠' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Guai'              when @crs<='鱹' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Guan'              when @crs<='撗' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Guang'              when @crs<='鱥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gui'              when @crs<='謴' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Gun'              when @crs<='腂' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Guo'              when @crs<='哈' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ha'              when @crs<='饚' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hai'              when @crs<='鶾' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Han'              when @crs<='沆' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hang'              when @crs<='兞' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hao'              when @crs<='靏' ColLATE Chinese_PRC_CS_AS_KS_WS then 'He'              when @crs<='嬒' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hei'              when @crs<='恨' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hen'              when @crs<='堼' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Heng'              when @crs<='鬨' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hong'              when @crs<='鱟' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hou'              when @crs<='鸌' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hu'              when @crs<='蘳' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hua'              when @crs<='蘾' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Huai'              when @crs<='鰀' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Huan'              when @crs<='鎤' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Huang'              when @crs<='顪' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hui'              when @crs<='諢' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Hun'              when @crs<='夻' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Huo'              when @crs<='驥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ji'              when @crs<='嗧' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Jia'              when @crs<='鑳' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Jian'              when @crs<='謽' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Jiang'              when @crs<='釂' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Jiao'              when @crs<='繲' ColLATE Chinese_PRC_CS_AS_KS_WS then 'JIE'              when @crs<='齽' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Jin'              when @crs<='竸' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Jing'              when @crs<='蘔' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Jiong'              when @crs<='欍' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Jiu'              when @crs<='爠' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ju'              when @crs<='羂' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Juan'              when @crs<='钁' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Jue'              when @crs<='攈' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Jun'              when @crs<='鉲' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ka'              when @crs<='乫' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kai'              when @crs<='矙' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kan'              when @crs<='閌' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kang'              when @crs<='鯌' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kao'              when @crs<='騍' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ke'              when @crs<='褃' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ken'              when @crs<='鏗' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Keng'              when @crs<='廤' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kong'              when @crs<='鷇' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kou'              when @crs<='嚳' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ku'              when @crs<='骻' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kua'              when @crs<='鱠' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kuai'              when @crs<='窾' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kuan'              when @crs<='鑛' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kuang'              when @crs<='鑎' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kui'              when @crs<='睏' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kun'              when @crs<='穒' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Kuo'              when @crs<='鞡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'La'              when @crs<='籟' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Lai'              when @crs<='糷' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Lan'              when @crs<='唥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Lang'              when @crs<='軂' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Lao'              when @crs<='餎' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Le'              when @crs<='脷' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Lei'              when @crs<='睖' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Leng'              when @crs<='瓈' ColLATE Chinese_PRC_CS_AS_KS_WS then 'li'              when @crs<='倆' ColLATE Chinese_PRC_CS_AS_KS_WS then 'lia'              when @crs<='纞' ColLATE Chinese_PRC_CS_AS_KS_WS then 'lian'              when @crs<='鍄' ColLATE Chinese_PRC_CS_AS_KS_WS then 'liang'              when @crs<='瞭' ColLATE Chinese_PRC_CS_AS_KS_WS then 'liao'              when @crs<='鱲' ColLATE Chinese_PRC_CS_AS_KS_WS then 'LIE'              when @crs<='轥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'lin'              when @crs<='炩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'ling'              when @crs<='咯' ColLATE Chinese_PRC_CS_AS_KS_WS then 'liu'              when @crs<='贚' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Long'              when @crs<='鏤' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Lou'              when @crs<='氇' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Lu'              when @crs<='鑢' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Lv'              when @crs<='亂' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Luan'              when @crs<='擽' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Lue'              when @crs<='論' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Lun'              when @crs<='鱳' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Luo'              when @crs<='嘛' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ma'              when @crs<='霢' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Mai'              when @crs<='蘰' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Man'              when @crs<='蠎' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Mang'              when @crs<='唜' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Mao'              when @crs<='癦' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Me'              when @crs<='嚜' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Mei'              when @crs<='們' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Men'              when @crs<='霥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Meng'              when @crs<='羃' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Mi'              when @crs<='麵' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Mian'              when @crs<='廟' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Miao'              when @crs<='鱴' ColLATE Chinese_PRC_CS_AS_KS_WS then 'MIE'              when @crs<='鰵' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Min'              when @crs<='詺' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ming'              when @crs<='謬' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Miu'              when @crs<='耱' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Mo'              when @crs<='麰' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Mou'              when @crs<='旀' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Mu'              when @crs<='魶' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Na'              when @crs<='錼' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nai'              when @crs<='婻' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nan'              when @crs<='齉' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nang'              when @crs<='臑' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nao'              when @crs<='呢' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ne'              when @crs<='焾' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nei'              when @crs<='嫩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nen'              when @crs<='能' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Neng'              when @crs<='嬺' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ni'              when @crs<='艌' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nian'              when @crs<='釀' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Niang'              when @crs<='脲' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Niao'              when @crs<='钀' ColLATE Chinese_PRC_CS_AS_KS_WS then 'NIE'              when @crs<='拰' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nin'              when @crs<='濘' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ning'              when @crs<='靵' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Niu'              when @crs<='齈' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nong'              when @crs<='譳' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nou'              when @crs<='搙' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nu'              when @crs<='衄' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nv'              when @crs<='瘧' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nue'              when @crs<='燶' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nuan'              when @crs<='桛' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Nuo'              when @crs<='鞰' ColLATE Chinese_PRC_CS_AS_KS_WS then 'O'              when @crs<='漚' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ou'              when @crs<='袙' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pa'              when @crs<='磗' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pai'              when @crs<='鑻' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pan'              when @crs<='胖' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pang'              when @crs<='礮' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pao'              when @crs<='轡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pei'              when @crs<='喯' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pen'              when @crs<='喸' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Peng'              when @crs<='鸊' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pi'              when @crs<='騙' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pian'              when @crs<='慓' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Piao'              when @crs<='嫳' ColLATE Chinese_PRC_CS_AS_KS_WS then 'PIE'              when @crs<='聘' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pin'              when @crs<='蘋' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ping'              when @crs<='魄' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Po'              when @crs<='哛' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pou'              when @crs<='曝' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Pu'              when @crs<='蟿' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qi'              when @crs<='髂' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qia'              when @crs<='縴' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qian'              when @crs<='瓩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qiang'              when @crs<='躈' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qiao'              when @crs<='籡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'QIE'              when @crs<='藽' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qin'              when @crs<='櫦' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qing'              when @crs<='瓗' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qiong'              when @crs<='糗' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qiu'              when @crs<='覻' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qu'              when @crs<='勸' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Quan'              when @crs<='礭' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Que'              when @crs<='囕' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Qun'              when @crs<='橪' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ran'              when @crs<='讓' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Rang'              when @crs<='繞' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Rao'              when @crs<='熱' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Re'              when @crs<='餁' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ren'              when @crs<='陾' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Reng'              when @crs<='馹' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ri'              when @crs<='穃' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Rong'              when @crs<='嶿' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Rou'              when @crs<='擩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ru'              when @crs<='礝' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ruan'              when @crs<='壡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Rui'              when @crs<='橍' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Run'              when @crs<='鶸' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ruo'              when @crs<='栍' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Sa'              when @crs<='虄' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Sai'              when @crs<='閐' ColLATE Chinese_PRC_CS_AS_KS_WS then 'San'              when @crs<='喪' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Sang'              when @crs<='髞' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Sao'              when @crs<='飋' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Se'              when @crs<='篸' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Sen'              when @crs<='縇' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Seng'              when @crs<='霎' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Sha'              when @crs<='曬' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shai'              when @crs<='鱔' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shan'              when @crs<='緔' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shang'              when @crs<='潲' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shao'              when @crs<='欇' ColLATE Chinese_PRC_CS_AS_KS_WS then 'She'              when @crs<='瘮' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shen'              when @crs<='賸' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Sheng'              when @crs<='瓧' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shi'              when @crs<='鏉' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shou'              when @crs<='虪' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shu'              when @crs<='誜' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shua'              when @crs<='卛' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shuai'              when @crs<='腨' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shuan'              when @crs<='灀' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shuang'              when @crs<='睡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shui'              when @crs<='鬊' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shun'              when @crs<='鑠' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Shuo'              when @crs<='乺' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Si'              when @crs<='鎹' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Song'              when @crs<='瘶' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Sou'              when @crs<='鷫' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Su'              when @crs<='算' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Suan'              when @crs<='鐩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Sui'              when @crs<='潠' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Sun'              when @crs<='蜶' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Suo'              when @crs<='襨' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ta'              when @crs<='燤' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tai'              when @crs<='賧' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tan'              when @crs<='燙' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tang'              when @crs<='畓' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tao'              when @crs<='蟘' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Te'              when @crs<='朰' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Teng'              when @crs<='趯' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ti'              when @crs<='舚' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tian'              when @crs<='糶' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tiao'              when @crs<='餮' ColLATE Chinese_PRC_CS_AS_KS_WS then 'TIE'              when @crs<='乭' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ting'              when @crs<='憅' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tong'              when @crs<='透' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tou'              when @crs<='鵵' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tu'              when @crs<='褖' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tuan'              when @crs<='駾' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tui'              when @crs<='坉' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tun'              when @crs<='籜' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Tuo'              when @crs<='韤' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Wa'              when @crs<='顡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Wai'              when @crs<='贎' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Wan'              when @crs<='朢' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Wang'              when @crs<='躛' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Wei'              when @crs<='璺' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Wen'              when @crs<='齆' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Weng'              when @crs<='齷' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Wo'              when @crs<='鶩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Wu'              when @crs<='衋' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xi'              when @crs<='鏬' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xia'              when @crs<='鼸' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xian'              when @crs<='鱌' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xiang'              when @crs<='斆' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xiao'              when @crs<='躞' ColLATE Chinese_PRC_CS_AS_KS_WS then 'XIE'              when @crs<='釁' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xin'              when @crs<='臖' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xing'              when @crs<='敻' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xiong'              when @crs<='齅' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xiu'              when @crs<='蓿' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xu'              when @crs<='贙' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xuan'              when @crs<='瀥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xue'              when @crs<='鑂' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Xun'              when @crs<='齾' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ya'              when @crs<='灩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yan'              when @crs<='樣' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yang'              when @crs<='鑰' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yao'              when @crs<='岃' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ye'              when @crs<='齸' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yi'              when @crs<='檼' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yin'              when @crs<='譍' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ying'              when @crs<='喲' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yo'              when @crs<='醟' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yong'              when @crs<='鼬' ColLATE Chinese_PRC_CS_AS_KS_WS then 'You'              when @crs<='爩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yu'              when @crs<='願' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yuan'              when @crs<='鸙' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yue'              when @crs<='韻' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Yun'              when @crs<='雥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Za'              when @crs<='縡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zai'              when @crs<='饡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zan'              when @crs<='臟' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zang'              when @crs<='竈' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zao'              when @crs<='稄' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Ze'              when @crs<='鱡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zei'              when @crs<='囎' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zen'               when @crs<='贈' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zeng'              when @crs<='醡' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zha'              when @crs<='瘵' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhai'              when @crs<='驏' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhan'              when @crs<='瞕' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhang'              when @crs<='羄' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhao'              when @crs<='鷓' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhe'              when @crs<='黮' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhen'              when @crs<='證' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zheng'              when @crs<='豒' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhi'              when @crs<='諥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhong'              when @crs<='驟' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhou'              when @crs<='鑄' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhu'              when @crs<='爪' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhua'              when @crs<='跩' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhuai'              when @crs<='籑' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhuan'              when @crs<='戅' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhuang'              when @crs<='鑆' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhui'              when @crs<='稕' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhun'              when @crs<='籱' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zhuo'              when @crs<='漬' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zi'              when @crs<='縱' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zong'              when @crs<='媰' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zou'              when @crs<='謯' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zu'              when @crs<='攥' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zuan'              when @crs<='欈' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zui'              when @crs<='銌' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zun'              when @crs<='咗' ColLATE Chinese_PRC_CS_AS_KS_WS then 'Zuo'              else  @crs [email protected],@[email protected]          end       return(@re)      END      GO      SELECT dbo.fn_GetQuanPin('拿来主义')      /*      NaLaiZhuYi      */  

以上是内存溢出(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

总结

以上是内存溢出为你收集整理的SQLServer汉字转全拼音函数全部内容，希望文章能够帮你解决SQLServer汉字转全拼音函数所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。