MSSQL 生成拼音码
2024-10-16 04:59:27
MSSQL 生成拼音码 /*==============================================================================
名称:fn_Get_Pin
功能:生成拼音码
创建:XXX
时间:2009年2月23日
==============================================================================*/
CREATE function [dbo].[fn_Get_Pin](@Str varchar(500)='')
returns varchar(500)
as
begin
declare @strlen int,@return varchar(500),@ii int
declare @n int,@c char(1),@chn nchar(1) select @strlen=len(@str),@return='',@ii=0
set @ii=0
while (@ii<@strlen)
begin
select @ii=@ii+1,@n=63,@chn=substring(@str,@ii,1)
if @chn>'z'
select @n = @n +1
,@c = case chn when @chn then char(@n) else @c end
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
else set @c=upper(@chn)
set @return=@return+@c
end
return(@return)
end GO
最新文章
- C# Entity Framework并发处理
- java21
- OpenStack学习参考
- 360chrome,google chrome浏览器使用jquery.ajax加载本地html文件
- NIS 报错No such map passwd.byname. Reason: Can&#39;t bind to server which serves this domain
- UML类图五种关系与代码的对应关系
- 学习总结——DOM
- 2. redis的数据类型
- apache 403错
- 浅谈对git的认识
- 解决PHP中file_get_contents抓取网页中文乱码问题
- php session already send by ……
- struts2令牌,防止重复提交
- Axis2(8):异步调用WebService
- HDOJ 4862 Jump
- DOM生成XML文档
- 6个Async/Await完胜Promise的原因
- [ 高危 ] my存在sql注入
- kafka.common.FailedToSendMessageException: Failed to send messages after 3 tries. 最无语的配置
- GPLT L2-004 这是二叉搜索树吗?