sql文字转换全拼_取汉字全拼的SQL函数

/*

根据汉字获取全拼

1.生成所有读音临时表

2.根据Chinese_PRC_CS_AS_KS_WS 排序获取读音

*/

CREATE function f_GetPinYin(@str varchar(100))

returns varchar(8000)

as

begin

declare @re varchar(8000)

--生成临时表

declare @t table(chr nchar(1) collate Chinese_PRC_CS_AS_KS_WS,py nvarchar(20))

insert into @t select'吖','a'

insert into @t select'厑','aes'

insert into @t select'哎','ai'

insert into @t select'安','an'

insert into @t select'肮','ang'

insert into @t select'凹','ao'

insert into @t select'八','ba'

insert into @t select'挀','bai'

insert into @t select'兡','baike'

insert into @t select'瓸','baiwa'

insert into @t select'扳','ban'

insert into @t select'邦','bang'

insert into @t select'勹','bao'

insert into @t select'萡','be'

insert into @t select'陂','bei'

insert into @t select'奔','ben'

insert into @t select'伻','beng'

insert into @t select'皀','bi'

insert into @t select'边','bian'

insert into @t select'辪','uu'

insert into @t select'灬','biao'

insert into @t select'憋','bie'

insert into @t select'汃','bin'

insert into @t select'冫','bing'

insert into @t select'癶','bo'

insert into @t select'峬','bu'

insert into @t select'嚓','ca'

insert into @t select'偲','cai'

insert into @t select'乲','cal'

insert into @t select'参','can'

insert into @t select'仓','cang'

insert into @t select'撡','cao'

insert into @t select'冊','ce'

insert into @t select'膥','cen'

insert into @t select'噌','ceng'

insert into @t select'硛','ceok'

insert into @t select'岾','ceom'

insert into @t select'猠','ceon'

insert into @t select'乽','ceor'

insert into @t select'叉','cha'

insert into @t select'犲','chai'

insert into @t select'辿','chan'

insert into @t select'伥','chang'

insert into @t select'抄','chao'

insert into @t select'车','che'

insert into @t select'抻','chen'

insert into @t select'阷','cheng'

insert into @t select'吃','chi'

insert into @t select'充','chong'

insert into @t select'抽','chou'

insert into @t select'出','chu'

insert into @t select'膗','chuai'

insert into @t select'巛','chuan'

insert into @t select'刅','chuang'

insert into @t select'吹','chui'

insert into @t select'旾','chun'

insert into @t select'踔','chuo'

insert into @t select'呲','ci'

insert into @t select'嗭','cis'

insert into @t select'从','cong'

insert into @t select'凑','cou'

insert into @t select'粗','cu'

insert into @t select'汆','cuan'

insert into @t select'崔','cui'

insert into @t select'邨','cun'

insert into @t select'瑳','cuo'

insert into @t select'撮','chua'

insert into @t select'咑','da'

insert into @t select'呔','dai'

insert into @t select'丹','dan'

insert into @t select'当','dang'

insert into @t select'刀','dao'

insert into @t select'恴','de'

insert into @t select'揼','dem'

insert into @t select'扥','den'

insert into @t select'灯','deng'

insert into @t select'仾','di'

insert into @t select'嗲','dia'

insert into @t select'敁','dian'

insert into @t select'刁','diao'

insert into @t select'爹','die'

insert into @t select'哋','dei'

insert into @t select'嚸','dim'

insert into @t select'丁','ding'

insert into @t select'丟','diu'

insert into @t select'东','dong'

insert into @t select'吺','dou'

insert into @t select'剢','du'

insert into @t select'耑','duan'

insert into @t select'叾','dug'

insert into @t select'垖','dui'

insert into @t select'吨','dun'

insert into @t select'咄','duo'

insert into @t select'妸','e'

insert into @t select'奀','en'

insert into @t select'鞥','eng'

insert into @t select'仒','eo'

insert into @t select'乻','eol'

insert into @t select'旕','eos'

insert into @t select'儿','er'

insert into @t select'发','fa'

insert into @t select'帆','fan'

insert into @t select'匚','fang'

insert into @t select'飞','fei'

insert into @t select'吩','fen'

insert into @t select'丰','feng'

insert into @t select'瓰','fenwa'

insert into @t select'覅','fiao'

insert into @t select'仏','fo'

insert into @t select'垺','fou'

insert into @t select'夫','fu'

insert into @t select'猤','fui'

insert into @t select'旮','ga'

insert into @t select'侅','gai'

insert into @t select'甘','gan'

insert into @t select'冈','gang'

insert into @t select'皋','gao'

insert into @t select'戈','ge'

insert into @t select'给','gei'

insert into @t select'根','gen'

insert into @t select'更','geng'

insert into @t select'啹','geu'

insert into @t select'喼','gib'

insert into @t select'嗰','go'

insert into @t select'工','gong'

insert into @t select'兝','gongfen'

insert into @t select'兣','gongli'

insert into @t select'勾','gou'

insert into @t select'估','gu'

insert into @t select'瓜','gua'

insert into @t select'乖','guai'

insert into @t select'关','guan'

insert into @t select'光','guang'

insert into @t select'归','gui'

insert into @t select'丨','gun'

insert into @t select'呙','guo'

insert into @t select'妎','ha'

insert into @t select'咍','hai'

insert into @t select'乤','hal'

insert into @t select'兯','han'

insert into @t select'魧','hang'

insert into @t select'茠','hao'

insert into @t select'兞','haoke'

insert into @t select'诃','he'

insert into @t select'