本篇文章主要介绍了"sql server 中文字段值转为拼音首字母"，主要涉及到方面的内容，对于SqlServer感兴趣的同学可以参考一下：
1、下面这个方法是中文转为拼音首字母方法create function dbo.fun_getPY(@str nvarchar(255)) returns nv...
1、下面这个方法是中文转为拼音首字母方法
create function dbo.fun_getPY(@str nvarchar(255))
returns nvarchar(50)
as
begin
declare @word nchar(1),@PY nvarchar(50)
set @PY=''
while len(@str)>0
begin
set @word=left(@str,1)
--如果非汉字字符，返回原字符
set @PY=@PY+(case when unicode(@word) between 19968 and 19968+20901
then (select top 1 PY from (
select 'A' as PY,N'骜' as word
union all select 'B',N'簿'
union all select 'C',N'错'
union all select 'D',N'鵽'
union all select 'E',N'樲'
union all select 'F',N'鳆'
union all select 'G',N'腂'
union all select 'H',N'夻'
union all select 'J',N'攈'
union all select 'K',N'穒'
union all select 'L',N'鱳'
union all select 'M',N'旀'
union all select 'N',N'桛'
union all select 'O',N'沤'
union all select 'P',N'曝'
union all select 'Q',N'囕'
union all select 'R',N'鶸'
union all select 'S',N'蜶'
union all select 'T',N'箨'
union all select 'W',N'鹜'
union all select 'X',N'鑂'
union all select 'Y',N'韵'
union all select 'Z',N'咗'
) T
where word>=@word collate Chinese_PRC_CS_AS_KS_WS
order by PY ASC) else @word end)
set @str=right(@str,len(@str)-1)
end
return @PY
end
GO
2、调用方法
update Price set PY_CODE = dbo.fun_getPY(ITEM_NAME)
PY_CODE 为拼音首字母字段，ITEM_NAME为需要转为拼音首字母的字段
以上就介绍了sql server 中文字段值转为拼音首字母，包括了方面的内容，希望对SqlServer有兴趣的朋友有所帮助。
本文网址链接：http://www.codes51.com/article/detail_102373.html
