《汉字转拼音函数》由会员分享,可在线阅读,更多相关《汉字转拼音函数(11页珍藏版)》请在金锄头文库上搜索。
-创建函数IF OBJECT_ID(fn_GetPinyin) IS NOT NULL DROP FUNCTION fn_GetPinyin GO create function dbo.fn_GetPinyin(words nvarchar(2000) returns varchar(8000) as begin declare word nchar(1) declare pinyin varchar(8000) declare i int declare words_len int declare unicode int set i = 1 set words = ltrim(rtrim(words) set words_len = len(words) while (i = word collate Chinese_PRC_CS_AS_KS_WS order by word collate Chinese_PRC_CS_AS_KS_WS ASC) else word end) set i = i + 1 end return pinyin END GO