通过sql server取出汉字的拼音.docVIP

SQL函数实现汉字模糊查询create function f_GetPy(@Str nvarchar(400))returns nvarchar(4000)asbegindeclare @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 八,Bunion all select 嚓,C union all select 咑,Dunion all select 妸,E union all select 发,Funion all select 旮,G union all select 铪,Hunion all select 丌,J union all select 咔,K union all select 垃,L union all select 嘸,Munion all select 拏,N union all select 噢,Ounion all select 妑,P union all select 七,Qunion all select 呥,R union all select 仨,Sunion all select 他,