導(dǎo)讀:1建站知識(shí)經(jīng)常要對(duì)姓名按拼音搜索,所以需要做如下函數(shù)來(lái)快速獲取首拼,需要的朋友可以參考下網(wǎng)站seo優(yōu)化課程建設(shè)網(wǎng)站。

代碼如下：

復(fù)制代碼 代碼如下:

USE [tempdb] GO /****** Object: UserDefinedFunction [dbo].[fun_getPY] Script Date: 05/23/2012 18:03:45 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /* 獲取漢字的首拼音 如果是非漢字字符 */ ALTER function [dbo].[fun_getPY] ( @str nvarchar(4000) ) returns nvarchar(4000) as begin declare @word nchar(1),@PY nvarchar(4000) 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'錯(cuò)' 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'籜' unio網(wǎng)站建設(shè)制作n網(wǎng)站seo優(yōu)化診斷工具 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 營(yíng)銷型網(wǎng)站建設(shè)upper(@PY) end

調(diào)用如下：

復(fù)制代碼 代碼如下:

select dbo.[fun_getPY]('中國(guó)人') 首拼

結(jié)果： ZGR相關(guān)網(wǎng)站seo優(yōu)化課程建設(shè)網(wǎng)站。

關(guān)鍵詞標(biāo)簽: 函數(shù) 漢字