零七网广告
代码如下:
/*
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' ','hei'
insert into @geovindu select N' ','hen'
insert into @geovindu select N'亨','heng'
insert into @geovindu select N' ','heui'
insert into @geovindu select N' ','ho'
insert into @geovindu select N' ','hol'
insert into @geovindu select N' ','hong'
insert into @geovindu select N' ','hou'
insert into @geovindu select N'乎','hu'
insert into @geovindu select N'花','hua'
insert into @geovindu select N'徊','huai'
insert into @geovindu select N'欢','huan'
insert into @geovindu select N' ','huang'
insert into @geovindu select N'灰','hui'
insert into @geovindu select N'昏','hun'
insert into @geovindu select N' ','huo'
insert into @geovindu select N' ','geo'
insert into @geovindu select N' ','hwa'
insert into @geovindu select N'丌','ji'
insert into @geovindu select N'加','jia'
insert into @geovindu select N' ','jialun'
insert into @geovindu select N'戋','jian'
insert into @geovindu select N'江','jiang'
insert into @geovindu select N'艽','jiao'
insert into @geovindu select N'阶','jie'
insert into @geovindu select N'巾','jin'
insert into @geovindu select N' ','jing'
insert into @geovindu select N'冂','jiong'
insert into @geovindu select N' ','jiu'
insert into @geovindu select N' ','jou'
insert into @geovindu select N' ','ju'
insert into @geovindu select N' ','juan'
insert into @geovindu select N'噘','jue'
insert into @geovindu select N'军','jun'
insert into @geovindu select N'咔','ka'
insert into @geovindu select N'开','kai'
insert into @geovindu select N' ','kal'
insert into @geovindu select N'刊','kan'
insert into @geovindu select N' ','hem'
insert into @geovindu select N' ','kang'
insert into @geovindu select N'尻','kao'
insert into @geovindu select N'坷','ke'
insert into @geovindu select N' ','ken'
insert into @geovindu select N' ','keng'
insert into @geovindu select N' ','keo'
insert into @geovindu select N' ','keol'
insert into @geovindu select N' ','keos'
insert into @geovindu select N' ','keum'
insert into @geovindu select N' ','ki'
insert into @geovindu select N'空','kong'
insert into @geovindu select N' ','kos'
insert into @geovindu select N'抠','kou'
insert into @geovindu select N' ','ku'
insert into @geovindu select N'夸','kua'
insert into @geovindu select N'蒯','kuai'
insert into @geovindu select N'宽','kuan'
insert into @geovindu select N'匡','kuang'
insert into @geovindu select N'亏','kui'
insert into @geovindu select N'坤','kun'
insert into @geovindu select N' ','kuo'
insert into @geovindu select N' ','kweok'
insert into @geovindu select N'垃','la'
insert into @geovindu select N'来','lai'
insert into @geovindu select N'兰','lan'
insert into @geovindu select N'啷','lang'
insert into @geovindu select N'捞','lao'
insert into @geovindu select N'仂','le'
insert into @geovindu select N'雷','lei'
insert into @geovindu select N'塄','leng'
insert into @geovindu select N' ','li'
insert into @geovindu select N'俩','lia'
insert into @geovindu select N' ','lian'
insert into @geovindu select N' ','liang'
insert into @geovindu select N' ','liao'
insert into @geovindu select N' ','lie'
insert into @geovindu select N' ','lin'
insert into @geovindu select N'伶','ling'
insert into @geovindu select N'溜','liu'
insert into @geovindu select N' ','liwa'
insert into @geovindu select N' ','lo'
insert into @geovindu select N'龙','long'
insert into @geovindu select N'娄','lou'
insert into @geovindu select N'噜','lu'
insert into @geovindu select N'驴','lv'
insert into @geovindu select N' ','lue'
insert into @geovindu select N'孪','luan'
insert into @geovindu select N' ','lun'
insert into @geovindu select N' ','luo'
insert into @geovindu select N' ','m'
insert into @geovindu select N'妈','ma'
insert into @geovindu select N' ','hweong'
insert into @geovindu select N'埋','mai'
insert into @geovindu select N'颟','man'
insert into @geovindu select N' ','mang'
insert into @geovindu select N' ','mangmi'
insert into @geovindu select N'猫','mao'
insert into @geovindu select N' ','mas'
insert into @geovindu select N' ','me'
insert into @geovindu select N' ','mei'
insert into @geovindu select N' ','men'
insert into @geovindu select N' ','meng'
insert into @geovindu select N' ','meo'
insert into @geovindu select N' ','mi'
insert into @geovindu select N'宀','mian'
insert into @geovindu select N'喵','miao'
insert into @geovindu select N'乜','mie'
insert into @geovindu select N' ','miliklanm'
insert into @geovindu select N'民','min'
insert into @geovindu select N' ','lem'
insert into @geovindu select N'名','ming'
insert into @geovindu select N'谬','miu'
insert into @geovindu select N'摸','mo'
insert into @geovindu select N' ','mol'
insert into @geovindu select N'哞','mou'
insert into @geovindu select N'母','mu'
insert into @geovindu select N' ','myeo'
insert into @geovindu select N' ','myeon'
insert into @geovindu select N' ','myeong'
insert into @geovindu select N' ','na'
insert into @geovindu select N' ','nai'
insert into @geovindu select N'囡','nan'
insert into @geovindu select N'囔','nang'
insert into @geovindu select N' ','keg'
insert into @geovindu select N'孬','nao'
insert into @geovindu select N'疒','ne'
insert into @geovindu select N' ','nei'
insert into @geovindu select N' ','nem'
insert into @geovindu select N'嫩','nen'
insert into @geovindu select N' ','neus'
insert into @geovindu select N' ','ngag'
insert into @geovindu select N' ','ngai'
insert into @geovindu select N' ','ngam'
insert into @geovindu select N'妮','ni'
insert into @geovindu select N'年','nian'
insert into @geovindu select N'娘','niang'
insert into @geovindu select N'茑','niao'
insert into @geovindu select N'捏','nie'
insert into @geovindu select N' ','nin'
insert into @geovindu select N'宁','ning'
insert into @geovindu select N'牛','niu'
insert into @geovindu select N'农','nong'
insert into @geovindu select N' ','nou'
insert into @geovindu select N'奴','nu'
insert into @geovindu select N'女','nv'
insert into @geovindu select N'疟','nue'
insert into @geovindu select N' ','nve'
insert into @geovindu select N' ','nuan'
insert into @geovindu select N' ','nun'
insert into @geovindu select N' ','nung'
insert into @geovindu select N'挪','nuo'
insert into @geovindu select N' ','o'
insert into @geovindu select N' ','oes'
insert into @geovindu select N'
零七网部分新闻及文章转载自互联网,供读者交流和学习,若有涉及作者版权等问题请及时与我们联系,以便更正、删除或按规定办理。感谢所有提供资讯的网站,欢迎各类媒体与零七网进行文章共享合作。
零七网广告