汉字转换拼音或拼音首字母(两个函数)
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
/*
根据汉字获取全拼
1.生成所有读音临时表
2.根据Chinese_PRC_CS_AS_KS_WS 排序获取读音
*/
create function f_GetPy(@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’撡’,'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 sel ect’抻’,'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 i nto @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’
in sert 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’
in sert into @t select’丹’,'dan’insert into @t select’当’,'dang’insert into @t select’刀’,'dao’