sql自动生成汉语拼音和首字母函数[转载]

根据汉字获取全拼 1.生成所有读音临时表 2.根据Chinese_PRC_CS_AS_KS_WS 排序获取读音 */ CREATE function f_GetPying(@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‘黒‘,‘hei‘ insert into @t select‘拫‘,‘hen‘ insert into @t select‘亨‘,‘heng‘ insert into @t select‘囍‘,‘heui‘ insert into @t select‘乊‘,‘ho‘ insert into @t select‘乥‘,‘hol‘ insert into @t select‘叿‘,‘hong‘ insert into @t select‘齁‘,‘hou‘ insert into @t select‘乎‘,‘hu‘ insert into @t select‘花‘,‘hua‘ insert into @t select‘徊‘,‘huai‘ insert into @t select‘欢‘,‘huan‘ insert into @t select‘巟‘,‘huang‘ insert into @t select‘灰‘,‘hui‘ insert into @t select‘昏‘,‘