/****** Object: UserDefinedFunction [dbo].[f_GetPinYin] Script Date: 11/01/2018 21:00:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER function [dbo].[f_GetPinYin](@str varchar(100))
returns varchar(8000)
as
begin
declare @re varchar(8000)
--生成临时表
declare @geovindu table(chr nchar(2) collate Chinese_PRC_CS_AS_KS_WS,py nvarchar(20))
insert into @geovindu select N'吖','a'
insert into @geovindu select N'厑','aes'
insert into @geovindu select N'哎','ai'
insert into @geovindu select N'安','an'
insert into @geovindu select N'肮','ang'
insert into @geovindu select N'凹','ao'
insert into @geovindu select N'八','ba'
insert into @geovindu select N'挀','bai'
insert into @geovindu select N'兡','baike'
insert into @geovindu select N'瓸','baiwa'
insert into @geovindu select N'扳','ban'
insert into @geovindu select N'邦','bang'
insert into @geovindu select N'勹','bao'
insert into @geovindu select N'萡','be'
insert into @geovindu select N'陂','bei'
insert into @geovindu select N'奔','ben'
insert into @geovindu select N'伻','beng'
insert into @geovindu select N'皀','bi'
insert into @geovindu select N'边','bian'
insert into @geovindu select N'辪','uu'
insert into @geovindu select N'灬','biao'
insert into @geovindu select N'憋','bie'
insert into @geovindu select N'汃','bin'
insert into @geovindu select N'冫','bing'
insert into @geovindu select N'癶','bo'
insert into @geovindu select N'峬','bu'
insert into @geovindu select N'嚓','ca'
insert into @geovindu select N'偲','cai'
insert into @geovindu select N'乲','cal'
insert into @geovindu select N'参','can'
insert into @geovindu select N'仓','cang'
insert into @geovindu select N'撡','cao'
insert into @geovindu select N'冊','ce'
insert into @geovindu select N'膥','cen'
insert into @geovindu select N'噌','ceng'
insert into @geovindu select N'硛','ceok'
insert into @geovindu select N'岾','ceom'
insert into @geovindu select N'猠','ceon'
insert into @geovindu select N'乽','ceor'
insert into @geovindu select N'叉','cha'
insert into @geovindu select N'犲','chai'
insert into @geovindu select N'辿','chan'
insert into @geovindu select N'伥','chang'
insert into @geovindu select N'抄','chao'
insert into @geovindu select N'车','che'
insert into @geovindu select N'抻','chen'
insert into @geovindu select N'阷','cheng'
insert into @geovindu select N'吃','chi'
insert into @geovindu select N'充','chong'
insert into @geovindu select N'抽','chou'
insert into @geovindu select N'出','chu'
insert into @geovindu select N'膗','chuai'
insert into @geovindu select N'巛','chuan'
insert into @geovindu select N'刅','chuang'
insert into @geovindu select N'吹','chui'
insert into @geovindu select N'旾','chun'
insert into @geovindu select N'踔','chuo'
insert into @geovindu select N'呲','ci'
insert into @geovindu select N'嗭','cis'
insert into @geovindu select N'从','cong'
insert into @geovindu select N'凑','cou'
insert into @geovindu select N'粗','cu'
insert into @geovindu select N'汆','cuan'
insert into @geovindu select N'崔','cui'
insert into @geovindu select N'邨','cun'
insert into @geovindu select N'瑳','cuo'
insert into @geovindu select N'撮','chua'
insert into @geovindu select N'咑','da'
insert into @geovindu select N'呔','dai'
insert into @geovindu select N'丹','dan'
insert into @geovindu select N'当','dang'
insert into @geovindu select N'刀','dao'
insert into @geovindu select N'恴','de'
insert into @geovindu select N'揼','dem'
insert into @geovindu select N'扥','den'
insert into @geovindu select N'灯','deng'
insert into @geovindu select N'仾','di'
insert into @geovindu select N'嗲','dia'
insert into @geovindu select N'敁','dian'
insert into @geovindu select N'刁','diao'
insert into @geovindu select N'爹','die'
insert into @geovindu select N'哋','dei'
insert into @geovindu select N'嚸','dim'
insert into @geovindu select N'丁','ding'
insert into @geovindu select N'丟','diu'
insert into @geovindu select N'东','dong'
insert into @geovindu select N'吺','dou'
insert into @geovindu select N'剢','du'
insert into @geovindu select N'耑','duan'
insert into @geovindu select N'叾','dug'
insert into @geovindu select N'垖','dui'
insert into @geovindu select N'吨','dun'
insert into @geovindu select N'咄','duo'
insert into @geovindu select N'妸','e'
insert into @geovindu select N'奀','en'
insert into @geovindu select N'鞥','eng'
insert into @geovindu select N'仒','eo'
insert into @geovindu select N'乻','eol'
insert into @geovindu select N'旕','eos'
insert into &
SQL Server中汉字转换成拼音
最新推荐文章于 2024-05-15 15:45:50 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)