sqlServer 获取汉字字串的拼音声母


复制代码 代码如下:

CREATE function fGetPy(@str varchar(500)='')
returns varchar(500)
as
begin
declare @strlen int,@return varchar(500),@ii int
declare @c nchar(1),@chn nchar(1)
select @strlen=len(@str),@return='',@ii=0
set @ii=0
while @ii<@strlen
begin
select @ii=@ii+1,@chn=substring(@str,@ii,1)
if @chn>='吖'
select @c = char(count(*)+63) from (
select top 27 * from (
select chn = '吖'
union all select '八'
union all select '嚓'
union all select '咑'
union all select '妸'
union all select '发'
union all select '旮'
union all select '铪'
union all select '丌' --because have no 'i'
union all select '丌'
union all select '咔'
union all select '垃'
union all select '嘸'
union all select '拏'
union all select '噢'
union all select '妑'
union all select '七'
union all select '呥'
union all select '仨'
union all select '他'
union all select '屲' --no 'u'
union all select '屲' --no 'v'
union all select '屲'
union all select '夕'
union all select '丫'
union all select '帀'
union all select @chn
) as a
order by chn COLLATE Chinese_PRC_CI_AS ) as b
where b.chn <=@chn
else set @c=@chn
set @return=@return+@c
end
return(@return)
end



相关阅读:
Linux下Makefile文件简单概念
更有效率的使用Linux键盘
分享AjaxPro或者Ajax实现机制
设计一个提示用户登录错误的表单
在RHEL4配置ftp服务详细的五个步骤
菜单 stepdown 呈递下沉的解决方法
asp.net(C#) Access 数据操作类
PHP 编程请选择正确的文本编辑软件
apache+mysql+php+ssl服务器之完全安装攻略
使用SyntaxHighlighter实现HTML高亮显示代码的方法
CSS教程:DIV元素与SPAN元素的区别
VBS教程:函数-StrComp 函数
探讨一种AJAX性能的改进方法
PHPMYADMIN 简明安装教程 推荐
快速导航

Copyright © 2016 phpStudy | 皖ICP备18014864号-4