SQL 根据汉字获取全拼的代码

/*
SQL 根据汉字获取全拼（有些字还没有添加上去，请自已加上去，涂聚文注）
生成所有读音临时表
根据Chinese_PRC_CS_AS_KS_WS 排序获取读音
geovindu@163.com 2009-12-2 其它功能請商討，我是在繁體的環境測試，簡體會更方便一些 。
*/
if exists(select 1 from sysobjects where name = f_GetPy and xtype = FN)
drop function f_GetPy
go
CREATE function f_GetPy(@str varchar(100))
returns varchar(8000)
as
begin
declare @re varchar(8000)
--生成临时表
--geovindu@163.com www.dusystem.com www.dupcit.com
declare @geovindu table(chr nchar(2) collate Chinese_PRC_CS_AS_KS_WS,py nvarchar(20))
insert into @geovindu select N吖,a
insert into @geovindu select N厑,aes
insert into @geovindu select N哎,ai
insert into @geovindu select N安,an
insert into @geovindu select N肮,ang
insert into @geovindu select N凹,ao
insert into @geovindu select N八,ba
insert into @geovindu select N挀,bai
insert into @geovindu select N兡,baike
insert into @geovindu select N瓸,baiwa
insert into @geovindu select N扳,ban
insert into @geovindu select N邦,bang
insert into @geovindu select N勹,bao
insert into @geovindu select N萡,be
insert into @geovindu select N陂,bei
insert into @geovindu select N奔,ben
insert into @geovindu select N伻,beng
insert into @geovindu select N皀,bi
insert into @geovindu select N边,bian
insert into @geovindu select N辪,uu
insert into @geovindu select N灬,biao
insert into @geovindu select N憋,bie
insert into @geovindu select N汃,bin
insert into @geovindu select N冫,bing
insert into @geovindu select N癶,bo
insert into @geovindu select N峬,bu
insert into @geovindu select N嚓,ca
insert into @geovindu select N偲,cai
insert into @geovindu select N乲,cal
insert into @geovindu select N参,can
insert into @geovindu select N仓,cang
insert into @geovindu select N撡,cao
insert into @geovindu select N冊,ce
insert into @geovindu select N膥,cen
insert into @geovindu select N噌,ceng
insert into @geovindu select N硛,ceok
insert into @geovindu select N岾,ceom
insert into @geovindu select N猠,ceon
insert into @geovindu select N乽,ceor
insert into @geovindu select N叉,cha
insert into @geovindu select N犲,chai
insert into @geovindu select N辿,chan
insert into @geovindu select N伥,chang
insert into @geovindu select N抄,chao
insert into @geovindu select N车,che
insert into @geovindu select N抻,chen
insert into @geovindu select N阷,cheng
insert into @geovindu select N吃,chi
insert into @geovindu select N充,chong
insert into @geovindu select N抽,chou
insert into @geovindu select N出,chu
insert into @geovindu select N膗,chuai
insert into @geovindu select N巛,chuan
insert into @geovindu select N刅,chuang
insert into @geovindu select N吹,chui
insert into @geovindu select N旾,chun
insert into @geovindu select N踔,chuo
insert into @geovindu select N呲,ci
insert into @geovindu select N嗭,cis
insert into @geovindu select N从,cong
insert into @geovindu select N凑,cou
insert into @geovindu select N粗,cu
insert into @geovindu select N汆,cuan
insert into @geovindu select N崔,cui
insert into @geovindu select N邨,cun
insert into @geovindu select N瑳,cuo
insert into @geovindu select N撮,chua
insert into @geovindu select N咑,da
insert into @geovindu select N呔,dai
insert into @geovindu select N丹,dan
insert into @geovindu select N当,dang
insert into @geovindu select N刀,dao
insert into @geovindu select N恴,de
insert into @geovindu select N揼,dem
insert into @geovindu select N扥,den
insert into @geovindu select N灯,deng
insert into @geovindu select N仾,di
insert into @geovindu select N嗲,dia
insert into @geovindu select N敁,dian
insert into @geovindu select N刁,diao
insert into @geovindu select N爹,die
insert into @geovindu select N哋,dei
insert into @geovindu select N嚸,dim
insert into @geovindu select N丁,ding
insert into @geovindu select N丟,diu
insert into @geovindu select N东,dong
insert into @geovindu select N吺,dou
insert into @geovindu select N剢,du
insert into @geovindu select N耑,duan
insert into @geovindu select N叾,dug
insert into @geovindu select N垖,dui
insert into @geovindu select N吨,dun
insert into @geovindu select N咄,duo
insert into @geovindu select N妸,e
insert into @geovindu select N奀,en
insert into @geovindu select N鞥,eng
insert into @geovindu select N仒,eo
insert into @geovindu select N乻,eol
insert into @geovindu select N旕,eos
insert into @geovindu select N儿,er
insert into @geovindu select N发,fa
insert into @geovindu select N帆,fan
insert into @geovindu select N匚,fang
insert into @geovindu select N飞,fei
insert into @geovindu select N吩,fen
insert into @geovindu select N丰,feng
insert into @geovindu select N瓰,fenwa
insert into @geovindu select N覅,fiao
insert into @geovindu select N仏,fo
insert into @geovindu select N垺,fou
insert into @geovindu select N夫,fu
insert into @geovindu select N猤,fui
insert into @geovindu select N旮,ga
insert into @geovindu select N侅,gai
insert into @geovindu select N甘,gan
insert into @geovindu select N冈,gang
insert into @geovindu select N皋,gao
insert into @geovindu select N戈,ge
insert into @geovindu select N给,gei
insert into @geovindu select N根,gen
insert into @geovindu select N更,geng
insert into @geovindu select N啹,geu
insert into @geovindu select N喼,gib
insert into @geovindu select N嗰,go
insert into @geovindu select N工,gong
insert into @geovindu select N兝,gongfen
insert into @geovindu select N兣,gongli
insert into @geovindu select N勾,gou
insert into @geovindu select N估,gu
insert into @geovindu select N瓜,gua
insert into @geovindu select N乖,guai
insert into @geovindu select N关,guan
insert into @geovindu select N光,guang
insert into @geovindu select N归,gui
insert into @geovindu select N丨,gun
insert into @geovindu select N呙,guo
insert into @geovindu select N妎,ha
insert into @geovindu select N咍,hai
insert into @geovindu select N乤,hal
insert into @geovindu select N兯,han
insert into @geovindu select N魧,hang
insert into @geovindu select N茠,hao
insert into @geovindu select N兞,haoke
insert into @geovindu select N诃,he
insert into @geovindu select N黒,hei
insert into @geovindu select N拫,hen
insert into @geovindu select N亨,heng
insert into @geovindu select N囍,heui
insert into @geovindu select N乊,ho
insert into @geovindu select N乥,hol
insert into @geovindu select N叿,hong
insert into @geovindu select N齁,hou
insert into @geovindu select N乎,hu
insert into @geovindu select N花,hua
insert into @geovindu select N徊,huai
insert into @geovindu select N欢,huan
insert into @geovindu select N巟,huang
insert into @geovindu select N灰,hui
insert into @geovindu select N昏,hun
insert into @geovindu select N吙,huo
insert into @geovindu select N嚿,geo
insert into @geovindu select N夻,hwa
insert into @geovindu select N丌,ji
insert into @geovindu select N加,jia
insert into @geovindu select N嗧,jialun
insert into @geovindu select N戋,jian
insert into @geovindu select N江,jiang
insert into @geovindu select N艽,jiao
insert into @geovindu select N阶,jie
insert into @geovindu select N巾,jin
insert into @geovindu select N坕,jing
insert into @geovindu select N冂,jiong
insert into @geovindu select N丩,jiu
insert into @geovindu select N欍,jou
insert into @geovindu select N凥,ju
insert into @geovindu select N姢,juan
insert into @geovindu select N噘,jue
insert into @geovindu select N军,jun
insert into @geovindu select N咔,ka
insert into @geovindu select N开,kai
insert into @geovindu select N乫,kal
insert into @geovindu select N刊,kan
insert into @geovindu select N冚,hem
insert into @geovindu select N砊,kang
insert into @geovindu select N尻,kao
insert into @geovindu select N坷,ke
insert into @geovindu select N肎,ken
insert into @geovindu select N劥,keng
insert into @geovindu select N巪,keo
insert into @geovindu select N乬,keol
insert into @geovindu select N唟,keos
insert into @geovindu select N厼,keum
insert into @geovindu select N怾,ki
insert into @geovindu select N空,kong
insert into @geovindu select N廤,kos
insert into @geovindu select N抠,kou
insert into @geovindu select N扝,ku
insert into @geovindu select N夸,kua
insert into @geovindu select N蒯,kuai
insert into @geovindu select N宽,kuan
insert into @geovindu select N匡,kuang
insert into @geovindu select N亏,kui
insert into @geovindu select N坤,kun
insert into @geovindu select N拡,kuo
insert into @geovindu select N穒,kweok
insert into @geovindu select N垃,la
insert into @geovindu select N来,lai
insert into @geovindu select N兰,lan
insert into @geovindu select N啷,lang
insert into @geovindu select N捞,lao
insert into @geovindu select N仂,le
insert into @geovindu select N雷,lei
insert into @geovindu select N塄,leng
insert into @geovindu select N唎,li
insert into @geovindu select N俩,lia
insert into @geovindu select N嫾,lian
insert into @geovindu select N簗,liang
insert into @geovindu select N蹽,liao
insert into @geovindu select N毟,lie
insert into @geovindu select N厸,lin
insert into @geovindu select N伶,ling
insert into @geovindu select N溜,liu
insert into @geovindu select N瓼,liwa
insert into @geovindu select N囖,lo
insert into @geovindu select N龙,long
insert into @geovindu select N娄,lou
insert into @geovindu select N噜,lu
insert into @geovindu select N驴,lv
insert into @geovindu select N寽,lue
insert into @geovindu select N孪,luan
insert into @geovindu select N掄,lun
insert into @geovindu select N頱,luo
insert into @geovindu select N呣,m
insert into @geovindu select N妈,ma
insert into @geovindu select N遤,hweong
insert into @geovindu select N埋,mai
insert into @geovindu select N颟,man
insert into @geovindu select N牤,mang
insert into @geovindu select N匁,mangmi
insert into @geovindu select N猫,mao
insert into @geovindu select N唜,mas
insert into @geovindu select N庅,me
insert into @geovindu select N呅,mei
insert into @geovindu select N椚,men
insert into @geovindu select N掹,meng
insert into @geovindu select N踎,meo
insert into @geovindu select N瞇,mi
insert into @geovindu select N宀,mian
insert into @geovindu select N喵,miao
insert into @geovindu select N乜,mie
insert into @geovindu select N瓱,miliklanm
insert into @geovindu select N民,min
insert into @geovindu select N冧,lem
insert into @geovindu select N名,ming
insert into @geovindu select N谬,miu
insert into @geovindu select N摸,mo
insert into @geovindu select N乮,mol
insert into @geovindu select N哞,mou
insert into @geovindu select N母,mu
insert into @geovindu select N旀,myeo
insert into @geovindu select N丆,myeon
insert into @geovindu select N椧,myeong
insert into @geovindu select N拏,na
insert into @geovindu select N腉,nai
insert into @geovindu select N囡,nan
insert into @geovindu select N囔,nang
insert into @geovindu select N乪,keg
insert into @geovindu select N孬,nao
insert into @geovindu select N疒,ne
insert into @geovindu select N娞,nei
insert into @geovindu select N焾,nem
insert into @geovindu select N嫩,nen
insert into @geovindu select N莻,neus
insert into @geovindu select N鈪,ngag
insert into @geovindu select N銰,ngai
insert into @geovindu select N啱,ngam
insert into @geovindu select N妮,ni
insert into @geovindu select N年,nian
insert into @geovindu select N娘,niang
insert into @geovindu select N茑,niao
insert into @geovindu select N捏,nie
insert into @geovindu select N脌,nin
insert into @geovindu select N宁,ning
insert into @geovindu select N牛,niu
insert into @geovindu select N农,nong
insert into @geovindu select N羺,nou
insert into @geovindu select N奴,nu
insert into @geovindu select N女,nv
insert into @geovindu select N疟,nue
insert into @geovindu select N瘧,nve
insert into @geovindu select N奻,nuan
insert into @geovindu select N黁,nun
insert into @geovindu select N燶,nung
insert into @geovindu select N挪,nuo
insert into @geovindu select N筽,o
insert into @geovindu select N夞,oes
insert into @geovindu select N乯,ol
insert into @geovindu select N鞰,on
insert into @geovindu select N讴,ou
insert into @geovindu select N妑,pa
insert into @geovindu select N俳,pai
insert into @geovindu select N磗,pak
insert into @geovindu select N眅,pan
insert into @geovindu select N乓,pang
insert into @geovindu select N抛,pao
insert into @geovindu select N呸,pei
insert into @geovindu select N瓫,pen
insert into @geovindu select N匉,peng
insert into @geovindu select N浌,peol
insert into @geovindu select N巼,phas
insert into @geovindu select N闏,phdeng
insert into @geovindu select N乶,phoi
insert into @geovindu select N喸,phos
insert into @geovindu select N丕,pi
insert into @geovindu select N囨,pian
insert into @geovindu select N缥,piao
insert into @geovindu select N氕,pie
insert into @geovindu select N丿,pianpang
insert into @geovindu select N姘,pin
insert into @geovindu select N乒,ping
insert into @geovindu select N钋,po
insert into @geovindu select N剖,pou
insert into @geovindu select N哣,deo
insert into @geovindu select N兺,ppun
insert into @geovindu select N仆,pu
insert into @geovindu select N七,qi
insert into @geovindu select N掐,qia
insert into @geovindu select N千,qian
insert into @geovindu select N羌,qiang
insert into @geovindu select N兛,qianke
insert into @geovindu select N瓩,qianwa
insert into @geovindu select N悄,qiao
insert into @geovindu select N苆,qie
insert into @geovindu select N亲,qin
insert into @geovindu select N蠄,kem
insert into @geovindu select N氢,qing
insert into @geovindu select N銎,qiong
insert into @geovindu select N丘,qiu
insert into @geovindu select N曲,qu
insert into @geovindu select N迲,keop
insert into @geovindu select N峑,quan
insert into @geovindu select N蒛,que
insert into @geovindu select N夋,qun
insert into @geovindu select N亽,ra
insert into @geovindu select N囕,ram
insert into @geovindu select N呥,ran
insert into @geovindu select N穣,rang
insert into @geovindu select N荛,rao
insert into @geovindu select N惹,re
insert into @geovindu select N人,ren
insert into @geovindu select N扔,reng
insert into @geovindu select N日,ri
insert into @geovindu select N栄,rong
insert into @geovindu select N禸,rou
insert into @geovindu select N嶿,ru
insert into @geovindu select N撋,ruan
insert into @geovindu select N桵,rui
insert into @geovindu select N闰,run
insert into @geovindu select N叒,ruo
insert into @geovindu select N仨,sa
insert into @geovindu select N栍,saeng
insert into @geovindu select N毢,sai
insert into @geovindu select N虄,sal
insert into @geovindu select N三,san
insert into @geovindu select N桒,sang
insert into @geovindu select N掻,sao
insert into @geovindu select N色,se
insert into @geovindu select N裇,sed
insert into @geovindu select N聓,sei
insert into @geovindu select N森,sen
insert into @geovindu select N鬙,seng
insert into @geovindu select N閪,seo
insert into @geovindu select N縇,seon
insert into @geovindu select N杀,sha
insert into @geovindu select N筛,shai
insert into @geovindu select N山,shan
insert into @geovindu select N伤,shang
insert into @geovindu select N弰,shao
insert into @geovindu select N奢,she
insert into @geovindu select N申,shen
insert into @geovindu select N升,sheng
insert into @geovindu select N尸,shi
insert into @geovindu select N兙,shike
insert into @geovindu select N瓧,shiwa
insert into @geovindu select N収,shou
insert into @geovindu select N书,shu
insert into @geovindu select N刷,shua
insert into @geovindu select N摔,shuai
insert into @geovindu select N闩,shuan
insert into @geovindu select N双,shuang
insert into @geovindu select N谁,shei
insert into @geovindu select N脽,shui
insert into @geovindu select N吮,shun
insert into @geovindu select N哾,shuo
insert into @geovindu select N丝,si
insert into @geovindu select N螦,so
insert into @geovindu select N乺,sol
insert into @geovindu select N忪,song
insert into @geovindu select N凁,sou
insert into @geovindu select N苏,su
insert into @geovindu select N痠,suan
insert into @geovindu select N夊,sui
insert into @geovindu select N娑,suo
insert into @geovindu select N他,ta
insert into @geovindu select N襨,tae
insert into @geovindu select N囼,tai
insert into @geovindu select N坍,tan
insert into @geovindu select N铴,tang
insert into @geovindu select N仐,tao
insert into @geovindu select N畓,tap
insert into @geovindu select N忒,te
insert into @geovindu select N膯,teng
insert into @geovindu select N唞,teo
insert into @geovindu select N朰,teul
insert into @geovindu select N剔,ti
insert into @geovindu select N天,tian
insert into @geovindu select N旫,tiao
insert into @geovindu select N怗,tie
insert into @geovindu select N厅,ting
insert into @geovindu select N乭,tol
insert into @geovindu select N囲,tong
insert into @geovindu select N偷,tou
insert into @geovindu select N凸,tu
insert into @geovindu select N湍,tuan
insert into @geovindu select N推,tui
insert into @geovindu select N旽,tun
insert into @geovindu select N乇,tuo
insert into @geovindu select N屲,wa
insert into @geovindu select N歪,wai
insert into @geovindu select N乛,wan
insert into @geovindu select N尣,wang
insert into @geovindu select N危,wei
insert into @geovindu select N塭,wen
insert into @geovindu select N翁,weng
insert into @geovindu select N挝,wo
insert into @geovindu select N乌,wu
insert into @geovindu select N夕,xi
insert into @geovindu select N诶,ei
insert into @geovindu select N疨,xia
insert into @geovindu select N仙,xian
insert into @geovindu select N乡,xiang
insert into @geovindu select N灱,xiao
insert into @geovindu select N楔,xie
insert into @geovindu select N心,xin
insert into @geovindu select N星,xing
insert into @geovindu select N凶,xiong
insert into @geovindu select N休,xiu
insert into @geovindu select N旴,xu
insert into @geovindu select N昍,xuan
insert into @geovindu select N疶,xue
insert into @geovindu select N坃,xun
insert into @geovindu select N丫,ya
insert into @geovindu select N咽,yan
insert into @geovindu select N欕,eom
insert into @geovindu select N央,yang
insert into @geovindu select N涂,tu
insert into @geovindu select N聚,ju
insert into @geovindu select N文,wen
insert into @geovindu select N吆,yao
insert into @geovindu select N椰,ye
insert into @geovindu select N膶,yen
insert into @geovindu select N一,yi
insert into @geovindu select N乁,i
insert into @geovindu select N乚,yin
insert into @geovindu select N应,ying
insert into @geovindu select N哟,yo
insert into @geovindu select N佣,yong
insert into @geovindu select N优,you
insert into @geovindu select N迂,yu
insert into @geovindu select N囦,yuan
insert into @geovindu select N曰,yue
insert into @geovindu select N蒀,yun
insert into @geovindu select N帀,za
insert into @geovindu select N災,zai
insert into @geovindu select N兂,zan
insert into @geovindu select N牂,zang
insert into @geovindu select N遭,zao
insert into @geovindu select N啫,ze
insert into @geovindu select N贼,zei
insert into @geovindu select N怎,zen
insert into @geovindu select N曽,zeng
insert into @geovindu select N吒,zha
insert into @geovindu select N甴,gad
insert into @geovindu select N夈,zhai
insert into @geovindu select N毡,zhan
insert into @geovindu select N张,zhang
insert into @geovindu select N钊,zhao
insert into @geovindu select N蜇,zhe
insert into @geovindu select N贞,zhen
insert into @geovindu select N凧,zheng
insert into @geovindu select N之,zhi
insert into @geovindu select N中,zhong
insert into @geovindu select N州,zhou
insert into @geovindu select N劯,zhu
insert into @geovindu select N抓,zhua
insert into @geovindu select N专,zhuan
insert into @geovindu select N转,zhuai
insert into @geovindu select N妆,zhuang
insert into @geovindu select N骓,zhui
insert into @geovindu select N宒,zhun
insert into @geovindu select N卓,zhuo
insert into @geovindu select N孜,zi
insert into @geovindu select N唨,zo
insert into @geovindu select N宗,zong
insert into @geovindu select N棸,zou
insert into @geovindu select N哫,zu
insert into @geovindu select N劗,zuan
insert into @geovindu select N厜,zui
insert into @geovindu select N尊,zun
insert into @geovindu select N昨,zuo
insert into @geovindu select N孙,sun
insert into @geovindu select N斯,si

declare @strlen int
select @strlen=len(@str),@re=
while @strlen>0
begin
select top 1 @re=UPPER(substring(py,1,1) )+substring(py,2,len(py))+@re,@strlen=@strlen-1
from @geovindu a where chr<=substring(@str,@strlen,1)
order by chr collate Chinese_PRC_CS_AS_KS_WS desc
if @@rowcount=0
select @re=substring(@str,@strlen,1)+@re,@strlen=@strlen-1
end
return(@re)
end
GO