数据库|mysql教程
汉字字串,拼音声母
数据库-mysql教程
c 类源码下载,ubuntu投影范围不对,Tomcat启动时间怎么看,爬虫页面用户信息,php源码数据库在哪修改,镇江seo特色lzw
sqlServer 中 获取汉字字串的拼音声母，需要的朋友可以参考下。
QQ下单网站源码,ubuntu系统修复引导,tomcat+优先加载js,爬虫定制 价格,php网页绘制图,seo线下培训班seo博客lzw
新版爱看影院yy影院全站源码,vscode编译无法运行,ubuntu 桌面 休眠,tomcat配置网址映射,sqlite3乌班图安装,百度网盘 分享爬虫,php宽字节,疆内seo优化公司,什么的信的电影网站源码,扁平化宠物网站模板lzw
代码如下:
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
