以下的文章主要向大家讲述的是如何正确获取汉字字串的拼音声母在SQL Server数据库中,此文主要是通过其实际操作代码来引出其正确的操作步骤,以下就是实现其具体操作的内容的描述,希望在你今后的学习中会有所帮助。
- 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)
- 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
以上的相关内容就是对SQL Server数据库的介绍,望你能有所收获。
【编辑推荐】