SQL 根据汉字获取全拼的代码

/*
SQL 根据汉字获取全拼（有些字还没有添加上去，请自已加上去，涂聚文注）
生成所有读音临时表
根据Chinese_PRC_CS_AS_KS_WS 排序获取读音
geovindu@163.com 2009-12-2 其它功能請商討，我是在繁體的環境測試，簡體會更方便一些。
*/
if exists(select 1 from sysobjects where name = ‘f_GetPy’ and xtype = ‘FN’)
drop function f_GetPy
go
CREATE function f_GetPy(@str varchar(100))
returns varchar(8000)
as
begin
declare @re varchar(8000)
–生成临时表
–geovindu@163.com www.dusystem.com www.dupcit.com
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’