汉字转拼音函数

1、-创建函数IFOBJECT_ID('fn_GetPinyin')ISNOTNULLDROPFUNCTIONfn_GetPinyinGOcreatefunctiondbo.fn_GetPinyin(wordsnvarchar(2000)returnsvarchar(8000)asbegindeclarewordnchar(1)declarepinyinvarchar(8000)declareiintdeclarewords_lenintdeclareunicodeintseti=1setwords=ltrim(rtrim(words)setwords_len=len(words)

2、while(i<=words_len)-循环取字符beginsetword=substring(words,i,1)setunicode=unicode(word)setpinyin=ISNULL(pinyin+SPACE(1),'')+(casewhenunicode(word)between19968and19968+20901then(selecttop1pyfrom(select'a'aspy,N吧aswordunionallselect'ai',N'囊unionallselect'an',N黯unional

3、lselect'ang',N'酸unionallselect'ao',N'甯unionallselect'ba',N桶unionallselect'bai',N'通-unionallselect'ban',N瓣unionallselect'bang',N露unionallselect'bao',N献unionallselect'bei',N嬖unionallselect'ben',N'M'unionallsele

4、ct'beng',N'B'unionallselect'bi',N'Hunionallselect'bian',N建unionallselect'biao',N螺unionallselect'bie',N瞥unionallselect'bin',N鬟unionallselect'bing',N'蠹unionallselect'bo',N'W'unionallselect'bu',N'簿uniona

5、llselect'ca',N'靴unionallselect'cai',N姿-,舞姿unionallselect'can',N熠unionallselect'cang',N''unionallselect'cao',N饕unionallselect'ce',N'箝unionallselect'cen',N'签unionallselect'ceng',N'翥-协磕帖骐翥unionallselect'cha'

6、,Nteunionallselect'chai',N嗤unionallselect'chan',NSTunionallselect'chang',N辗unionallselect'chao',N眇unionallselect'che',N燃unionallselect'chen',N粉unionallselect'cheng',N矛Funionallselect'chi',N鬻unionallselect'chong',Nunionallselect&

7、#39;chou',N殡unionallselect'chu',N矗unionallselect'chuai',N踹unionallselect'chuan',N翦unionallselect'chuang',N'忖unionallselect'chui',N境unionallselect'chun',N蠢unionallselect'chuo',N粽unionallselect'ci',N亳-题亳unionallselect'cong'

8、;,N激unionallselect'cou',N蝶unionallselect'cu',N时unionallselect'cuan',N爨unionallselect'cui',N脾unionallselect'cun',N对unionallselect'cuo',Nunionallselect'da',N楂unionallselect'dai',N魏unionallselect'dan',N饕unionallselect'dang'

9、,NKunionallselect'dao',N蠢unionallselect'de',N的11unionallselect'den',N'捶unionallselect'deng',N'鞭'unionallselect'di',N'蠕unionallselect'dia',N哮unionallselect'dian',N'Wunionallselect'diao',N'B'unionallselect'

10、die',N'嘶-睦嘶unionallselect'ding',N宵unionallselect'diu',N物unionallselect'dong',N需unionallselect'dou',N,副unionallselect'du',N蠹,unionallselect'duan',N'匕,-籥匕unionallselect'dui',N,trunionallselect'dun',N'踮'unionallselect&#

11、39;duo',N,翦unionallselect'e',N'jg'unionallselect'en',N'掘,unionallselect'eng',N鞫,unionallselect'er',N,植unionallselect'fa',N鬓,unionallselect'fan',N,翳unionallselect'fang',N放unionallselect'fei',N,舞unionallselect'fen'

12、,N,M,unionallselect'feng',N,要unionallselect'fo',N,柳unionallselect'fou',N,稳unionallselect'fu',N'揆,-蝮揆unionallselect'ga',N就unionallselect'gai',N,璘,unionallselect'gan',N,瀚,unionallselect'gang',N,麓unionallselect'gao',N金告unionall

13、select'ge',N猖unionallselect'gei',N,unionallselect'gen',N掴unionallselect'geng',N'埴'-互埴喝噫嘲unionallselect'gong',N,魅,镇赣勉魅unionallselect'gou',N,瞒,unionallselect'gu',N,爵unionallselect'gua',N,言圭,unionallselect'guai',N'Wunio

14、nallselect'guan',N'罐unionallselect'guang',N'撞'unionallselect'gui',N觞unionallselect'gun',N'm'unionallselect'guo',N月果unionallselect'ha',N'哈,unionallselect'hai',N'皤unionallselect'han',N'H'unionallselect&

15、#39;hang',N沆unionallselect'hao',N'蔻unionallselect'he',N'霸unionallselect'hei',N嫡unionallselect'hen',N恨unionallselect'heng',N里-里爵unionallselect'hong',N时unionallselect'hou',N第unionallselect'hu',N,矍,unionallselect'hua',N

16、,部,unionallselect'huai',N,物unionallselect'huan',N,簸,unionallselect'huang',N,B,unionallselect'hui',N,ITunionallselect'hun',N,Wunionallselect'huo',N杏,unionallselectji',N犍,unionallselect'jia',N鬻,unionallselect'jian',N,徽unionallselect&#

17、39;jiang',N,薯'unionallselect'jiao',N,醵,unionallselect'jie',N,Wunionallselect'jin',N舞,unionallselect'jing',N,赢unionallselect'jiong',N覆,unionallselect'jiu',N槽,unionallselect'ju',N熠,unionallselect'juan',N需,unionallselect'jue

18、9;,N'it,unionallselect'jun',N,攫,unionallselect'ka',N金卡,unionallselect'kai',N,雪-H翌unionallselect'kan',N,曦,unionallselect'kang',N''unionallselect'kao',N'能'unionallselect'ke',N,聘unionallselect'ken',N褶,unionallselect'

19、;keng',N'B'1皂盍余惧unionallselect'kong',N,阳unionallselect'kou',N'毂,unionallselect'ku',N'歙unionallselect'kua',N'聘,unionallselect'kuai',N'rn'unionallselect'kuan',N'a'unionallselect'kuang',N'm'unionalls

20、elect'kui',N金置unionallselect'kun',N'胭,unionallselect'kuo',N'B'unionallselect'la',N帽unionallselect'lai',N'M'unionallselect'lan',N'椭,unionallselect'lang',N哈,unionallselect'lao',N,卿unionallselect'le',N'燃

21、,unionallselect'lei',N'W-嘲删unionallselect'leng',N陵,unionallselect'li',N'璨,unionallselect'lia',N'ffi,unionallselect'lian',N,粽unionallselect'liang',N船unionallselect'liao',N瞭,unionallselect'lie',N,蒯unionallselect'lin',N

22、,画-辅拎unionallselect'ling',N'岭unionallselect'liu',N'咯,-腥瞋噬咯unionallselect'long',N'H'unionallselect'lou',N,鲫unionallselect'lu',N'稽,unionallselect'lv',N''unionallselect'luan',N,酊unionallselect'lue',N'操,union

23、allselect'lun',N,粉unionallselect'luo',N磔,unionallselect'ma',N'嘛unionallselect'mai',N,霰unionallselect'man',N'靖unionallselect'mang',N'蟒unionallselect'mao',N'超unionallselect'me',N'糜-糜哎unionallselect'mei',N'嘿

24、unionallselect'men',N仲Tunionallselect'meng',N'橐籍踏unionallselect'mi',N'骞unionallselect'mian',N'就unionallselect'miao',N'unionallselect'mie',N'B'-鲫！unionallselect'min',N警unionallselect'ming',N晶unionallselect'miu

25、',N''unionallselect'mo',N'耨-耨空unionallselect'mou',N'舞-舜麒unionallselect'mu',N'旅unionallselect'na',N'蒯unionallselect'nai',N'琮unionallselect'nan',N'蝴unionallselect'nang',N'朦unionallselect'nao',N月需uni

26、onallselect'ne',N'呢unionallselect'nei',N'烧-嫩烧unionallselect'nen',N嫩unionallselect'neng',N'能'嗯正喏unionallselect'ni',N'嬷unionallselect'nian',N舲;unionallselect'niang',N'瞰unionallselect'niao',N服unionallselect'nie&

27、#39;,N献unionallselect'nin',N'推unionallselect'ning',N的unionallselect'niu',N靶unionallselect'nong',N疆unionallselect'nou',N'it'unionallselect'nu',N'樨unionallselect'nv',N'M'unionallselect'nue',N'B'unionallsele

28、ct'nuan',N燃-碟磨燃邮unionallselect'nuo',N'1'unionallselect'o',N'暇'撞船塞昭unionallselect'ou',N'湛unionallselect'pa',N汨unionallselect'pai',N'礴-unionallselect'pan',N'津unionallselect'pang',N胖unionallselect'pao',N

29、碳unionallselect'pei',N'曹unionallselect'pen',N峰unionallselect'peng',N/-洪品更:成unionallselect'pi',N,疆unionallselect'pian',N,卿unionallselect'piao',N'，瞟,unionallselect'pie',N嘤unionallselect'pin',N聘,unionallselect'ping',N,好unio

30、nallselect'po',N魄unionallselect'pou',N与-忿券unionallselect'pu',N曝unionallselect'qi',N螯unionallselect'qia',N,能,unionallselect'qian',N獐unionallselect'qiang',N旺-谖起旺unionallselect'qiao',N,蹶unionallselect'qie',N,籁,unionallselect'qi

31、n',N藕unionallselect'qing',N橙unionallselect'qiong',N璃unionallselect'qiu',N模unionallselect'qu',N,觑unionallselect'quan',N,的unionallselect'que',N,罐unionallselect'qun',N嘴unionallselect'ran',N燃,unionallselect'rang',N,需unionallsele

32、ct'rao',N,unionallselect're',N熟unionallselect'ren',N,闹unionallselect'reng',N澳,unionallselect'ri',N周日unionallselect'rong',N,榕,unionallselect'rou',N,崎unionallselect'ru',N,犒unionallselect'ruan',N'孺unionallselect'rui',N卷

33、unionallselect'run',N桐-桐接unionallselect'ruo',N'i|'unionallselect'sa',N性-襟性unionallselect'sai',N'醺'-塞醺unionallselect'san',N围unionallselect'sang',N'W'unionallselect'sao',N'B'unionallselect'se',N'H'-

34、褴骨unionallselect'sen',N'察unionallselect'seng',nyr解宣unionallselect'sha',N霎unionallselect'shai',N瞰unionallselect'shan',N的unionallselect'shang',Nfunionallselect'shao',N瀚unionallselect'she',N撮unionallselect'shen',N疼unionallselec

35、t'sheng',N除unionallselect'shi',N'社-BOMBunionallselect'shou',N徽unionallselect'shu',N雕unionallselect'shua',N言交unionallselect'shuai',N窣unionallselect'shuan',N月Tunionallselect'shuang',N'濡unionallselect'shui',N睡unionallselect

36、'shun',N暮unionallselect'shuo',N雄unionallselect'si',N曳-溺螺曳unionallselect'song',N金Tunionallselect'sou',N癞unionallselect'su',N'munionallselect'suan',N算unionallselect'sui',N豳unionallselect'sun',N漫unionallselect'suo',N蟀un

37、ionallselect'ta',N曲-躅禅unionallselect'tai',N夕Munionallselect'tan',NMunionallselect'tang',N费unionallselect'tao',N奋-言寸奋unionallselect'te',N'蟆unionallselect'teng',N'交客唱交unionallselect'ti',N'整unionallselect'tian',N瞻uniona

38、llselect'tiao',N'耀'unionallselect'tie',N'餐unionallselect'ting',N'豆一涕豆unionallselect'tong',N'熟unionallselect'tou',N'透unionallselect'tu',N'陶unionallselect'tuan',N未象'unionallselect'tui',N脱unionallselect'

39、tun',N'坤unionallselect'tuo',N'舞unionallselect'wa',N'辕'unionallselect'wai',N寂unionallselect'wan',N瞩unionallselect'wang',NH'unionallselect'wei',N'蹩unionallselect'wen',N'翦unionallselect'weng',N麓unionallselec

40、t'wo',N'龌unionallselect'wu',N'篇unionallselect'xi',N蠹unionallselect'xia',N罅unionallselect'xian',N'睥unionallselect'xiang',N'W'unionallselect'xiao',N数unionallselect'xie',N嘤unionallselect'xin',N橐unionallselect

41、9;xing',N署unionallselect'xiong',N贽unionallselect'xiu',N鼻臭unionallselect'xu',N蓿unionallselect'xuan',N暨unionallselect'xue',N濯unionallselect'xun',NHunionallselect'ya',N爵unionallselect'yan',N激unionallselect'yang',N檬unionallselect'yao',Naunionallselect'ye',N步'-缴|胴为unionallselect'yi',N酶unionallselect'yin',N槎unionallselect'ying',N鹰unionallselect'yo',N'啕unionallselect'yong',N'管unionallselect'you',N鼬unionallselect'yu',N艘unionallselect'