|
<div class="codetitle"><a style="CURSOR: pointer" data="66520" class="copybut" id="copybut66520" onclick="doCopy('code66520')"> 代码如下:<div class="codebody" id="code66520">
/
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' （编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
