首页 > 数据库

MSSQL汉字转拼音函数

时间:2009-06-01 18:28:27  作者:OSnow  我要投稿
Linux初探欢迎您的投稿,投放方法请点击这里查看,我们会定期赠送精美小礼品给优秀的投稿作者。海纳百川 取则行远!LinuxGoo欢迎您的到来。
/* -------------------------------------------------------------函数: fn_GetPinyin描述: 汉字转拼音(无数据表版)使用: dbo.fn_GetPinyin('中华人民共和国'......

union all select ''yao'',N''鑰''
union all select ''ye'',N''岃'' --鸈膶岃
union all select ''yi'',N''齸''
union all select ''yin'',N''檼''
union all select ''ying'',N''譍''
union all select ''yo'',N''喲''
union all select ''yong'',N''醟''
union all select ''you'',N''鼬''
union all select ''yu'',N''爩''
union all select ''yuan'',N''願''
union all select ''yue'',N''鸙''
union all select ''yun'',N''韻''
union all select ''za'',N''雥''
union all select ''zai'',N''縡''
union all select ''zan'',N''饡''
union all select ''zang'',N''臟''
union all select ''zao'',N''竈''
union all select ''ze'',N''稄''
union all select ''zei'',N''鱡''
union all select ''zen'',N''囎''
union all select ''zeng'',N''贈''
union all select ''zha'',N''醡''
union all select ''zhai'',N''瘵''
union all select ''zhan'',N''驏''
union all select ''zhang'',N''瞕''
union all select ''zhao'',N''羄''
union all select ''zhe'',N''鷓''
union all select ''zhen'',N''黮''
union all select ''zheng'',N''證''
union all select ''zhi'',N''豒''
union all select ''zhong'',N''諥''
union all select ''zhou'',N''驟''
union all select ''zhu'',N''鑄''
union all select ''zhua'',N''爪''
union all select ''zhuai'',N''跩''
union all select ''zhuan'',N''籑''
union all select ''zhuang'',N''戅''
union all select ''zhui'',N''鑆''
union all select ''zhun'',N''稕''
union all select ''zhuo'',N''籱''
union all select ''zi'',N''漬'' --漬唨
union all select ''zong'',N''縱''
union all select ''zou'',N''媰''
union all select ''zu'',N''謯''
union all select ''zuan'',N''攥''
union all select ''zui'',N''欈''
union all select ''zun'',N''銌''
union all select ''zuo'',N''咗'') t where word >= @word collate Chinese_PRC_CS_AS_KS_WS order by word ASC) else @word end)
set @i = @i 1
end
return @pinyin
end
'
END
GO

如果您需转载 MSSQL汉字转拼音函数,请注明来自LinuxGoo.com,其版权归原作者所有。请广大网友留言时遵纪守法,使用文明用语。如果您在应用中有什么问题,请在下面留言,我们会尽快解答。
来顶一下
近回首页
返回首页
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表
相关文章
栏目热门