SQL中有多种的函数，下面为您介绍sql中汉字转换为拼音的函数，供您参考。数据库中先自定义一个函数，再把下面代码写进去，功能是得到汉字拼音首字母：
如下：
view source print ?
01 | createfunctionfun_getPY(@str nvarchar(4000)) |
02 | returnsnvarchar(4000) |
03 | as |
04 | begin |
05 | declare@word nchar(1),@PY nvarchar(4000) |
06 | set@PY='' |
07 | while len(@str)>0 |
08 | begin |
09 | set@word=left(@str,1) |
10 | --如果非汉字字符，返回原字符 |
11 | set@PY=@PY+(casewhenunicode(@word) between19968 and19968+20901 |
12 | then(selecttop1 PY from( |
13 | select'A'asPY,N'驁'asword |
14 | unionallselect'B',N'簿' |
15 | unionallselect'C',N'錯' |
16 | unionallselect'D',N'鵽' |
17 | unionallselect'E',N'樲' |
18 | unionallselect'F',N'鰒' |
19 | unionallselect'G',N'腂' |
20 | unionallselect'H',N'夻' |
21 | unionallselect'J',N'攈' |
22 | unionallselect'K',N'穒' |
23 | unionallselect'L',N'鱳' |
24 | unionallselect'M',N'旀' |
25 | unionallselect'N',N'桛' |
26 | unionallselect'O',N'漚' |
27 | unionallselect'P',N'曝' |
28 | unionallselect'Q',N'囕' |
29 | unionallselect'R',N'鶸' |
30 | unionallselect'S',N'蜶' |
31 | unionallselect'T',N'籜' |
32 | unionallselect'W',N'鶩' |
33 | unionallselect'X',N'鑂' |
34 | unionallselect'Y',N'韻' |
35 | unionallselect'Z',N'咗' |
36 | ) T |
37 | whereword>=@word collateChinese_PRC_CS_AS_KS_WS |
38 | orderbyPY ASC) else@word end) |
39 | set@str=right(@str,len(@str)-1) |
40 | end |
41 | return@PY |
42 | end |
–函数调用实例：
select dbo.fun_getPY(‘中华人民共和国’)
结果都为：ZHRMGHG
【编辑推荐】
SQL中的ISNULL函数介绍
Sql语言中的日期格式化函数getDate()
详解SQL中的SUBSTRING函数
SQL中的CHARINDEX函数
SQL中自定义函数的存储过程的区别
文章来源网络，作者：运维，如若转载，请注明出处：https://shuyeidc.com/wp/291337.html<
