拼音识别汉字函数.docVIP

-------------------------------------SQL拼音识别汉字函数语句----------------------- set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go --创建取拼音函数 ALTER function [dbo].[f_GetPy](@Str nvarchar(400)) returns nvarchar(4000) as begin declare @strlen int,@re nvarchar(4000) declare @t table(chr nchar(1) collate Chinese_PRC_CI_AS,letter nchar(1)) insert @t select 吖,A union all select 八,B union all select 嚓,C union all select 咑,D union all select 妸,E union all select 发,F union all select 旮,G union all select 铪,H union all select 丌,J union all select 咔,K union all select 垃,L union all select 嘸,M union