sql取拼音(全拼).docVIP

sql取拼音(全拼) sql取拼音(全拼).txt——某天你一定会感谢那个遗弃你的人，感谢那个你曾深爱着却置之你不顾的人。做一个没心没肺的人,比什么都强。________舍不得又怎样到最后还不是说散就散。 /* 根据汉字获取全拼 1.生成所有读音临时表 2.根据Chinese_PRC_CS_AS_KS_WS 排序获取读音 */ create function f_GetAllPy(@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 @