sql数据库
自定义一个函数
把下面代码写进去
功能是得到汉字拼音
create function [dbo].[fn_Getquanpin]
(
@str nvarchar(100)
)
returns varchar(8000)
as
begin
declare @re varchar(8000),@crs nvarchar(10)
declare @strlen int
select @strlen=len(@str),@re=''
while @strlen>0
begin
set @crs= substring(@str,@strlen,1)
select @re=
case
when (@crs collate Chinese_PRC_CS_AS_KS_WS) < N'吖' then @crs
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'厑' then 'A'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'靉' then 'Ai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'黯' then 'AN'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'醠' then 'Ang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'驁' then 'Ao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'欛' then 'Ba'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瓸' then 'Bai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瓣' then 'BaN'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鎊' then 'Bang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑤' then 'Bao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鐾' then 'Bei'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'輽' then 'BeN'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鏰' then 'Beng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鼊' then 'Bi'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'變' then 'BiaN'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鰾' then 'Biao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'彆' then 'Bie'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鬢' then 'Bin'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'靐' then 'Bing'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蔔' then 'Bo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'簿' then 'Bu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'囃' then 'Ca'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'乲' then 'Cai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'爘' then 'Can'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'賶' then 'Cang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鼜' then 'Cao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'簎' then 'Ce'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'笒' then 'Cen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'乽' then 'Ceng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'詫' then 'Cha'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'囆' then 'Chai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'顫' then 'Chan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'韔' then 'Chang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'觘' then 'Chao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'爡' then 'Che'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'讖' then 'Chen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'秤' then 'Cheng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鷘' then 'Chi'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'銃' then 'Chong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'殠' then 'Chou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'矗' then 'Chu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'踹' then 'Chuai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鶨' then 'Chuan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'愴' then 'Chuang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'顀' then 'Chui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蠢' then 'Chun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'縒' then 'Chuo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嗭' then 'Ci'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'謥' then 'Cong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'輳' then 'Cou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'顣' then 'Cu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'爨' then 'Cuan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'臎' then 'Cui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'籿' then 'Cun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'錯' then 'Cuo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'橽' then 'Da'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'靆' then 'Dai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'饏' then 'Dan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'闣' then 'Dang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'纛' then 'Dao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'的' then 'De'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'扽' then 'Den'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鐙' then 'Deng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'螮' then 'Di'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嗲' then 'Dia'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'驔' then 'Dian'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑃' then 'Diao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嚸' then 'Die'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'顁' then 'Ding'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'銩' then 'Diu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'霘' then 'Dong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鬭' then 'Dou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蠹' then 'Du'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'叾' then 'Duan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'譵' then 'Dui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'踲' then 'Dun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鵽' then 'Duo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱷' then 'E'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'摁' then 'En'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鞥' then 'Eng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'樲' then 'Er'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'髮' then 'Fa'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瀪' then 'Fan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'放' then 'Fang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'靅' then 'Fei'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱝' then 'Fen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'覅' then 'Feng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'梻' then 'Fo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鴀' then 'Fou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'猤' then 'Fu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'魀' then 'Ga'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瓂' then 'Gai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'灨' then 'Gan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'戇' then 'Gang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鋯' then 'Gao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'獦' then 'Ge'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'給' then 'Gei'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'搄' then 'Gen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'堩' then 'Geng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'兣' then 'Gong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'購' then 'Gou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'顧' then 'Gu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'詿' then 'Gua'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'恠' then 'Guai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱹' then 'Guan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'撗' then 'Guang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱥' then 'Gui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'謴' then 'Gun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'腂' then 'Guo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'哈' then 'Ha'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'饚' then 'Hai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鶾' then 'Han'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'沆' then 'Hang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'兞' then 'Hao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'靏' then 'He'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嬒' then 'Hei'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'恨' then 'Hen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'堼' then 'Heng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鬨' then 'Hong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱟' then 'Hou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鸌' then 'Hu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蘳' then 'Hua'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蘾' then 'Huai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鰀' then 'Huan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鎤' then 'Huang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'顪' then 'Hui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'諢' then 'Hun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'夻' then 'Huo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'驥' then 'Ji'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嗧' then 'Jia'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑳' then 'Jian'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'謽' then 'Jiang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'釂' then 'Jiao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'繲' then 'Jie'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'齽' then 'Jin'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'竸' then 'Jing'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蘔' then 'Jiong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'欍' then 'Jiu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'爠' then 'Ju'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'羂' then 'Juan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'钁' then 'Jue'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'攈' then 'Jun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鉲' then 'Ka'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'乫' then 'Kai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'矙' then 'Kan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'閌' then 'Kang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鯌' then 'Kao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'騍' then 'Ke'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'褃' then 'Ken'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鏗' then 'Keng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'廤' then 'Kong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鷇' then 'Kou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嚳' then 'Ku'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'骻' then 'Kua'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱠' then 'Kuai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'窾' then 'Kuan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑛' then 'Kuang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑎' then 'Kui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'睏' then 'Kun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'穒' then 'Kuo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鞡' then 'La'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'籟' then 'Lai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'糷' then 'Lan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'唥' then 'Lang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'軂' then 'Lao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'餎' then 'Le'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'脷' then 'Lei'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'睖' then 'Leng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瓈' then 'Li'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'倆' then 'Lia'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'纞' then 'Lian'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鍄' then 'Liang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瞭' then 'Liao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱲' then 'Lie'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'轥' then 'Lin'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'炩' then 'Ling'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'咯' then 'Liu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'贚' then 'Long'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鏤' then 'Lou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'氇' then 'Lu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑢' then 'Lv'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'亂' then 'Luan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'擽' then 'Lue'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'論' then 'Lun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱳' then 'Luo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嘛' then 'Ma'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'霢' then 'Mai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蘰' then 'Man'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蠎' then 'Mang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'唜' then 'Mao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'癦' then 'Me'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嚜' then 'Mei'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'們' then 'Men'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'霥' then 'Meng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'羃' then 'Mi'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'麵' then 'Mian'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'廟' then 'Miao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱴' then 'Mie'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鰵' then 'Min'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'詺' then 'Ming'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'謬' then 'Miu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'耱' then 'Mo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'麰' then 'Mou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'旀' then 'Mu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'魶' then 'Na'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'錼' then 'Nai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'婻' then 'Nan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'齉' then 'Nang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'臑' then 'Nao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'呢' then 'Ne'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'焾' then 'Nei'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嫩' then 'Nen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'能' then 'Neng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嬺' then 'Ni'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'艌' then 'Nian'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'釀' then 'Niang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'脲' then 'Niao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'钀' then 'Nie'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'拰' then 'Nin'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'濘' then 'Ning'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'靵' then 'Niu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'齈' then 'Nong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'譳' then 'Nou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'搙' then 'Nu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'衄' then 'Nv'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瘧' then 'Nue'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'燶' then 'Nuan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'桛' then 'Nuo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鞰' then 'O'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'漚' then 'Ou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'袙' then 'Pa'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'磗' then 'Pai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑻' then 'Pan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'胖' then 'Pang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'礮' then 'Pao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'轡' then 'Pei'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'喯' then 'Pen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'喸' then 'Peng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鸊' then 'Pi'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'騙' then 'Pian'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'慓' then 'Piao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嫳' then 'Pie'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'聘' then 'Pin'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蘋' then 'Ping'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'魄' then 'Po'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'哛' then 'Pou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'曝' then 'Pu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蟿' then 'Qi'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'髂' then 'Qia'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'縴' then 'Qian'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瓩' then 'Qiang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'躈' then 'Qiao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'籡' then 'Qie'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'藽' then 'Qin'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'櫦' then 'Qing'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瓗' then 'Qiong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'糗' then 'Qiu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'覻' then 'Qu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'勸' then 'Quan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'礭' then 'Que'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'囕' then 'Qun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'橪' then 'Ran'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'讓' then 'Rang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'繞' then 'Rao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'熱' then 'Re'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'餁' then 'Ren'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'陾' then 'Reng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'馹' then 'Ri'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'穃' then 'Rong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'嶿' then 'Rou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'擩' then 'Ru'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'礝' then 'Ruan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'壡' then 'Rui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'橍' then 'Run'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鶸' then 'Ruo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'栍' then 'Sa'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'虄' then 'Sai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'閐' then 'San'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'喪' then 'Sang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'髞' then 'Sao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'飋' then 'Se'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'篸' then 'Sen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'縇' then 'Seng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'霎' then 'Sha'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'曬' then 'Shai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱔' then 'Shan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'緔' then 'Shang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'潲' then 'Shao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'欇' then 'She'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瘮' then 'Shen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'賸' then 'Sheng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瓧' then 'Shi'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鏉' then 'Shou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'虪' then 'Shu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'誜' then 'Shua'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'卛' then 'Shuai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'腨' then 'Shuan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'灀' then 'Shuang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'睡' then 'Shui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鬊' then 'Shun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑠' then 'Shuo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'乺' then 'Si'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鎹' then 'Song'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瘶' then 'Sou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鷫' then 'Su'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'算' then 'Suan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鐩' then 'Sui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'潠' then 'Sun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蜶' then 'Suo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'襨' then 'Ta'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'燤' then 'Tai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'賧' then 'Tan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'燙' then 'Tang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'畓' then 'Tao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蟘' then 'Te'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'朰' then 'Teng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'趯' then 'Ti'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'舚' then 'Tian'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'糶' then 'Tiao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'餮' then 'Tie'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'乭' then 'Ting'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'憅' then 'Tong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'透' then 'Tou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鵵' then 'Tu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'褖' then 'Tuan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'駾' then 'Tui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'坉' then 'Tun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'籜' then 'Tuo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'韤' then 'Wa'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'顡' then 'Wai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'贎' then 'Wan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'朢' then 'Wang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'躛' then 'Wei'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'璺' then 'Wen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'齆' then 'Weng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'齷' then 'Wo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鶩' then 'Wu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'衋' then 'Xi'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鏬' then 'Xia'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鼸' then 'Xian'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱌' then 'Xiang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'斆' then 'Xiao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'躞' then 'Xie'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'釁' then 'Xin'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'臖' then 'Xing'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'敻' then 'Xiong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'齅' then 'Xiu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'蓿' then 'Xu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'贙' then 'Xuan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瀥' then 'Xue'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑂' then 'Xun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'齾' then 'Ya'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'灩' then 'Yan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'樣' then 'Yang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑰' then 'Yao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'岃' then 'Ye'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'齸' then 'Yi'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'檼' then 'Yin'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'譍' then 'Ying'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'喲' then 'Yo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'醟' then 'Yong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鼬' then 'You'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'爩' then 'Yu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'願' then 'Yuan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鸙' then 'Yue'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'韻' then 'Yun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'雥' then 'Za'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'縡' then 'Zai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'饡' then 'Zan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'臟' then 'Zang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'竈' then 'Zao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'稄' then 'Ze'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鱡' then 'Zei'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'囎' then 'Zen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'贈' then 'Zeng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'醡' then 'Zha'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瘵' then 'Zhai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'驏' then 'Zhan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'瞕' then 'Zhang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'羄' then 'Zhao'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鷓' then 'Zhe'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'黮' then 'Zhen'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'證' then 'Zheng'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'豒' then 'Zhi'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'諥' then 'Zhong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'驟' then 'Zhou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑄' then 'Zhu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'爪' then 'Zhua'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'跩' then 'Zhuai'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'籑' then 'Zhuan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'戅' then 'Zhuang'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'鑆' then 'Zhui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'稕' then 'Zhun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'籱' then 'Zhuo'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'漬' then 'Zi'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'縱' then 'Zong'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'媰' then 'Zou'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'謯' then 'Zu'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'攥' then 'Zuan'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'欈' then 'Zui'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'銌' then 'Zun'
when (@crs collate Chinese_PRC_CS_AS_KS_WS) <= N'咗' then 'Zuo'
else @crs
end+@re,@strlen=@strlen-1
end
return(@re)
end
go
select dbo.fn_Getquanpin (N'你好,我是月亮哥!')
go