服务器之家:专注于服务器技术及软件下载分享
分类导航

Mysql|Sql Server|Oracle|Redis|MongoDB|PostgreSQL|Sqlite|DB2|mariadb|Access|数据库技术|

服务器之家 - 数据库 - Sql Server - SQL 根据汉字获取全拼的代码

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

2019-11-19 15:29SQL教程网 Sql Server

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' 
insert into @geovindu select N'膥','cen' 
insert into @geovindu select N'噌','ceng' 
insert into @geovindu select N'硛','ceok' 
insert into @geovindu select N'岾','ceom' 
insert into @geovindu select N'猠','ceon' 
insert into @geovindu select N'乽','ceor' 
insert into @geovindu select N'叉','cha' 
insert into @geovindu select N'犲','chai' 
insert into @geovindu select N'辿','chan' 
insert into @geovindu select N'伥','chang' 
insert into @geovindu select N'抄','chao' 
insert into @geovindu select N'车','che' 
insert into @geovindu select N'抻','chen' 
insert into @geovindu select N'阷','cheng' 
insert into @geovindu select N'吃','chi' 
insert into @geovindu select N'充','chong' 
insert into @geovindu select N'抽','chou' 
insert into @geovindu select N'出','chu' 
insert into @geovindu select N'膗','chuai' 
insert into @geovindu select N'巛','chuan' 
insert into @geovindu select N'刅','chuang' 
insert into @geovindu select N'吹','chui' 
insert into @geovindu select N'旾','chun' 
insert into @geovindu select N'踔','chuo' 
insert into @geovindu select N'呲','ci' 
insert into @geovindu select N'嗭','cis' 
insert into @geovindu select N'从','cong' 
insert into @geovindu select N'凑','cou' 
insert into @geovindu select N'粗','cu' 
insert into @geovindu select N'汆','cuan' 
insert into @geovindu select N'崔','cui' 
insert into @geovindu select N'邨','cun' 
insert into @geovindu select N'瑳','cuo' 
insert into @geovindu select N'撮','chua' 
insert into @geovindu select N'咑','da' 
insert into @geovindu select N'呔','dai' 
insert into @geovindu select N'丹','dan' 
insert into @geovindu select N'当','dang' 
insert into @geovindu select N'刀','dao' 
insert into @geovindu select N'恴','de' 
insert into @geovindu select N'揼','dem' 
insert into @geovindu select N'扥','den' 
insert into @geovindu select N'灯','deng' 
insert into @geovindu select N'仾','di' 
insert into @geovindu select N'嗲','dia' 
insert into @geovindu select N'敁','dian' 
insert into @geovindu select N'刁','diao' 
insert into @geovindu select N'爹','die' 
insert into @geovindu select N'哋','dei' 
insert into @geovindu select N'嚸','dim' 
insert into @geovindu select N'丁','ding' 
insert into @geovindu select N'丟','diu' 
insert into @geovindu select N'东','dong' 
insert into @geovindu select N'吺','dou' 
insert into @geovindu select N'剢','du' 
insert into @geovindu select N'耑','duan' 
insert into @geovindu select N'叾','dug' 
insert into @geovindu select N'垖','dui' 
insert into @geovindu select N'吨','dun' 
insert into @geovindu select N'咄','duo' 
insert into @geovindu select N'妸','e' 
insert into @geovindu select N'奀','en' 
insert into @geovindu select N'鞥','eng' 
insert into @geovindu select N'仒','eo' 
insert into @geovindu select N'乻','eol' 
insert into @geovindu select N'旕','eos' 
insert into @geovindu select N'儿','er' 
insert into @geovindu select N'发','fa' 
insert into @geovindu select N'帆','fan' 
insert into @geovindu select N'匚','fang' 
insert into @geovindu select N'飞','fei' 
insert into @geovindu select N'吩','fen' 
insert into @geovindu select N'丰','feng' 
insert into @geovindu select N'瓰','fenwa' 
insert into @geovindu select N'覅','fiao' 
insert into @geovindu select N'仏','fo' 
insert into @geovindu select N'垺','fou' 
insert into @geovindu select N'夫','fu' 
insert into @geovindu select N'猤','fui' 
insert into @geovindu select N'旮','ga' 
insert into @geovindu select N'侅','gai' 
insert into @geovindu select N'甘','gan' 
insert into @geovindu select N'冈','gang' 
insert into @geovindu select N'皋','gao' 
insert into @geovindu select N'戈','ge' 
insert into @geovindu select N'给','gei' 
insert into @geovindu select N'根','gen' 
insert into @geovindu select N'更','geng' 
insert into @geovindu select N'啹','geu' 
insert into @geovindu select N'喼','gib' 
insert into @geovindu select N'嗰','go' 
insert into @geovindu select N'工','gong' 
insert into @geovindu select N'兝','gongfen' 
insert into @geovindu select N'兣','gongli' 
insert into @geovindu select N'勾','gou' 
insert into @geovindu select N'估','gu' 
insert into @geovindu select N'瓜','gua' 
insert into @geovindu select N'乖','guai' 
insert into @geovindu select N'关','guan' 
insert into @geovindu select N'光','guang' 
insert into @geovindu select N'归','gui' 
insert into @geovindu select N'丨','gun' 
insert into @geovindu select N'呙','guo' 
insert into @geovindu select N'妎','ha' 
insert into @geovindu select N'咍','hai' 
insert into @geovindu select N'乤','hal' 
insert into @geovindu select N'兯','han' 
insert into @geovindu select N'魧','hang' 
insert into @geovindu select N'茠','hao' 
insert into @geovindu select N'兞','haoke' 
insert into @geovindu select N'诃','he' 
insert into @geovindu select N'黒','hei' 
insert into @geovindu select N'拫','hen' 
insert into @geovindu select N'亨','heng' 
insert into @geovindu select N'囍','heui' 
insert into @geovindu select N'乊','ho' 
insert into @geovindu select N'乥','hol' 
insert into @geovindu select N'叿','hong' 
insert into @geovindu select N'齁','hou' 
insert into @geovindu select N'乎','hu' 
insert into @geovindu select N'花','hua' 
insert into @geovindu select N'徊','huai' 
insert into @geovindu select N'欢','huan' 
insert into @geovindu select N'巟','huang' 
insert into @geovindu select N'灰','hui' 
insert into @geovindu select N'昏','hun' 
insert into @geovindu select N'吙','huo' 
insert into @geovindu select N'嚿','geo' 
insert into @geovindu select N'夻','hwa' 
insert into @geovindu select N'丌','ji' 
insert into @geovindu select N'加','jia' 
insert into @geovindu select N'嗧','jialun' 
insert into @geovindu select N'戋','jian' 
insert into @geovindu select N'江','jiang' 
insert into @geovindu select N'艽','jiao' 
insert into @geovindu select N'阶','jie' 
insert into @geovindu select N'巾','jin' 
insert into @geovindu select N'坕','jing' 
insert into @geovindu select N'冂','jiong' 
insert into @geovindu select N'丩','jiu' 
insert into @geovindu select N'欍','jou' 
insert into @geovindu select N'凥','ju' 
insert into @geovindu select N'姢','juan' 
insert into @geovindu select N'噘','jue' 
insert into @geovindu select N'军','jun' 
insert into @geovindu select N'咔','ka' 
insert into @geovindu select N'开','kai' 
insert into @geovindu select N'乫','kal' 
insert into @geovindu select N'刊','kan' 
insert into @geovindu select N'冚','hem' 
insert into @geovindu select N'砊','kang' 
insert into @geovindu select N'尻','kao' 
insert into @geovindu select N'坷','ke' 
insert into @geovindu select N'肎','ken' 
insert into @geovindu select N'劥','keng' 
insert into @geovindu select N'巪','keo' 
insert into @geovindu select N'乬','keol' 
insert into @geovindu select N'唟','keos' 
insert into @geovindu select N'厼','keum' 
insert into @geovindu select N'怾','ki' 
insert into @geovindu select N'空','kong' 
insert into @geovindu select N'廤','kos' 
insert into @geovindu select N'抠','kou' 
insert into @geovindu select N'扝','ku' 
insert into @geovindu select N'夸','kua' 
insert into @geovindu select N'蒯','kuai' 
insert into @geovindu select N'宽','kuan' 
insert into @geovindu select N'匡','kuang' 
insert into @geovindu select N'亏','kui' 
insert into @geovindu select N'坤','kun' 
insert into @geovindu select N'拡','kuo' 
insert into @geovindu select N'穒','kweok' 
insert into @geovindu select N'垃','la' 
insert into @geovindu select N'来','lai' 
insert into @geovindu select N'兰','lan' 
insert into @geovindu select N'啷','lang' 
insert into @geovindu select N'捞','lao' 
insert into @geovindu select N'仂','le' 
insert into @geovindu select N'雷','lei' 
insert into @geovindu select N'塄','leng' 
insert into @geovindu select N'唎','li' 
insert into @geovindu select N'俩','lia' 
insert into @geovindu select N'嫾','lian' 
insert into @geovindu select N'簗','liang' 
insert into @geovindu select N'蹽','liao' 
insert into @geovindu select N'毟','lie' 
insert into @geovindu select N'厸','lin' 
insert into @geovindu select N'伶','ling' 
insert into @geovindu select N'溜','liu' 
insert into @geovindu select N'瓼','liwa' 
insert into @geovindu select N'囖','lo' 
insert into @geovindu select N'龙','long' 
insert into @geovindu select N'娄','lou' 
insert into @geovindu select N'噜','lu' 
insert into @geovindu select N'驴','lv' 
insert into @geovindu select N'寽','lue' 
insert into @geovindu select N'孪','luan' 
insert into @geovindu select N'掄','lun' 
insert into @geovindu select N'頱','luo' 
insert into @geovindu select N'呣','m' 
insert into @geovindu select N'妈','ma' 
insert into @geovindu select N'遤','hweong' 
insert into @geovindu select N'埋','mai' 
insert into @geovindu select N'颟','man' 
insert into @geovindu select N'牤','mang' 
insert into @geovindu select N'匁','mangmi' 
insert into @geovindu select N'猫','mao' 
insert into @geovindu select N'唜','mas' 
insert into @geovindu select N'庅','me' 
insert into @geovindu select N'呅','mei' 
insert into @geovindu select N'椚','men' 
insert into @geovindu select N'掹','meng' 
insert into @geovindu select N'踎','meo' 
insert into @geovindu select N'瞇','mi' 
insert into @geovindu select N'宀','mian' 
insert into @geovindu select N'喵','miao' 
insert into @geovindu select N'乜','mie' 
insert into @geovindu select N'瓱','miliklanm' 
insert into @geovindu select N'民','min' 
insert into @geovindu select N'冧','lem' 
insert into @geovindu select N'名','ming' 
insert into @geovindu select N'谬','miu' 
insert into @geovindu select N'摸','mo' 
insert into @geovindu select N'乮','mol' 
insert into @geovindu select N'哞','mou' 
insert into @geovindu select N'母','mu' 
insert into @geovindu select N'旀','myeo' 
insert into @geovindu select N'丆','myeon' 
insert into @geovindu select N'椧','myeong' 
insert into @geovindu select N'拏','na' 
insert into @geovindu select N'腉','nai' 
insert into @geovindu select N'囡','nan' 
insert into @geovindu select N'囔','nang' 
insert into @geovindu select N'乪','keg' 
insert into @geovindu select N'孬','nao' 
insert into @geovindu select N'疒','ne' 
insert into @geovindu select N'娞','nei' 
insert into @geovindu select N'焾','nem' 
insert into @geovindu select N'嫩','nen' 
insert into @geovindu select N'莻','neus' 
insert into @geovindu select N'鈪','ngag' 
insert into @geovindu select N'銰','ngai' 
insert into @geovindu select N'啱','ngam' 
insert into @geovindu select N'妮','ni' 
insert into @geovindu select N'年','nian' 
insert into @geovindu select N'娘','niang' 
insert into @geovindu select N'茑','niao' 
insert into @geovindu select N'捏','nie' 
insert into @geovindu select N'脌','nin' 
insert into @geovindu select N'宁','ning' 
insert into @geovindu select N'牛','niu' 
insert into @geovindu select N'农','nong' 
insert into @geovindu select N'羺','nou' 
insert into @geovindu select N'奴','nu' 
insert into @geovindu select N'女','nv' 
insert into @geovindu select N'疟','nue' 
insert into @geovindu select N'瘧','nve' 
insert into @geovindu select N'奻','nuan' 
insert into @geovindu select N'黁','nun' 
insert into @geovindu select N'燶','nung' 
insert into @geovindu select N'挪','nuo' 
insert into @geovindu select N'筽','o' 
insert into @geovindu select N'夞','oes' 
insert into @geovindu select N'乯','ol' 
insert into @geovindu select N'鞰','on' 
insert into @geovindu select N'讴','ou' 
insert into @geovindu select N'妑','pa' 
insert into @geovindu select N'俳','pai' 
insert into @geovindu select N'磗','pak' 
insert into @geovindu select N'眅','pan' 
insert into @geovindu select N'乓','pang' 
insert into @geovindu select N'抛','pao' 
insert into @geovindu select N'呸','pei' 
insert into @geovindu select N'瓫','pen' 
insert into @geovindu select N'匉','peng' 
insert into @geovindu select N'浌','peol' 
insert into @geovindu select N'巼','phas' 
insert into @geovindu select N'闏','phdeng' 
insert into @geovindu select N'乶','phoi' 
insert into @geovindu select N'喸','phos' 
insert into @geovindu select N'丕','pi' 
insert into @geovindu select N'囨','pian' 
insert into @geovindu select N'缥','piao' 
insert into @geovindu select N'氕','pie' 
insert into @geovindu select N'丿','pianpang' 
insert into @geovindu select N'姘','pin' 
insert into @geovindu select N'乒','ping' 
insert into @geovindu select N'钋','po' 
insert into @geovindu select N'剖','pou' 
insert into @geovindu select N'哣','deo' 
insert into @geovindu select N'兺','ppun' 
insert into @geovindu select N'仆','pu' 
insert into @geovindu select N'七','qi' 
insert into @geovindu select N'掐','qia' 
insert into @geovindu select N'千','qian' 
insert into @geovindu select N'羌','qiang' 
insert into @geovindu select N'兛','qianke' 
insert into @geovindu select N'瓩','qianwa' 
insert into @geovindu select N'悄','qiao' 
insert into @geovindu select N'苆','qie' 
insert into @geovindu select N'亲','qin' 
insert into @geovindu select N'蠄','kem' 
insert into @geovindu select N'氢','qing' 
insert into @geovindu select N'銎','qiong' 
insert into @geovindu select N'丘','qiu' 
insert into @geovindu select N'曲','qu' 
insert into @geovindu select N'迲','keop' 
insert into @geovindu select N'峑','quan' 
insert into @geovindu select N'蒛','que' 
insert into @geovindu select N'夋','qun' 
insert into @geovindu select N'亽','ra' 
insert into @geovindu select N'囕','ram' 
insert into @geovindu select N'呥','ran' 
insert into @geovindu select N'穣','rang' 
insert into @geovindu select N'荛','rao' 
insert into @geovindu select N'惹','re' 
insert into @geovindu select N'人','ren' 
insert into @geovindu select N'扔','reng' 
insert into @geovindu select N'日','ri' 
insert into @geovindu select N'栄','rong' 
insert into @geovindu select N'禸','rou' 
insert into @geovindu select N'嶿','ru' 
insert into @geovindu select N'撋','ruan' 
insert into @geovindu select N'桵','rui' 
insert into @geovindu select N'闰','run' 
insert into @geovindu select N'叒','ruo' 
insert into @geovindu select N'仨','sa' 
insert into @geovindu select N'栍','saeng' 
insert into @geovindu select N'毢','sai' 
insert into @geovindu select N'虄','sal' 
insert into @geovindu select N'三','san' 
insert into @geovindu select N'桒','sang' 
insert into @geovindu select N'掻','sao' 
insert into @geovindu select N'色','se' 
insert into @geovindu select N'裇','sed' 
insert into @geovindu select N'聓','sei' 
insert into @geovindu select N'森','sen' 
insert into @geovindu select N'鬙','seng' 
insert into @geovindu select N'閪','seo' 
insert into @geovindu select N'縇','seon' 
insert into @geovindu select N'杀','sha' 
insert into @geovindu select N'筛','shai' 
insert into @geovindu select N'山','shan' 
insert into @geovindu select N'伤','shang' 
insert into @geovindu select N'弰','shao' 
insert into @geovindu select N'奢','she' 
insert into @geovindu select N'申','shen' 
insert into @geovindu select N'升','sheng' 
insert into @geovindu select N'尸','shi' 
insert into @geovindu select N'兙','shike' 
insert into @geovindu select N'瓧','shiwa' 
insert into @geovindu select N'収','shou' 
insert into @geovindu select N'书','shu' 
insert into @geovindu select N'刷','shua' 
insert into @geovindu select N'摔','shuai' 
insert into @geovindu select N'闩','shuan' 
insert into @geovindu select N'双','shuang' 
insert into @geovindu select N'谁','shei' 
insert into @geovindu select N'脽','shui' 
insert into @geovindu select N'吮','shun' 
insert into @geovindu select N'哾','shuo' 
insert into @geovindu select N'丝','si' 
insert into @geovindu select N'螦','so' 
insert into @geovindu select N'乺','sol' 
insert into @geovindu select N'忪','song' 
insert into @geovindu select N'凁','sou' 
insert into @geovindu select N'苏','su' 
insert into @geovindu select N'痠','suan' 
insert into @geovindu select N'夊','sui' 
insert into @geovindu select N'娑','suo' 
insert into @geovindu select N'他','ta' 
insert into @geovindu select N'襨','tae' 
insert into @geovindu select N'囼','tai' 
insert into @geovindu select N'坍','tan' 
insert into @geovindu select N'铴','tang' 
insert into @geovindu select N'仐','tao' 
insert into @geovindu select N'畓','tap' 
insert into @geovindu select N'忒','te' 
insert into @geovindu select N'膯','teng' 
insert into @geovindu select N'唞','teo' 
insert into @geovindu select N'朰','teul' 
insert into @geovindu select N'剔','ti' 
insert into @geovindu select N'天','tian' 
insert into @geovindu select N'旫','tiao' 
insert into @geovindu select N'怗','tie' 
insert into @geovindu select N'厅','ting' 
insert into @geovindu select N'乭','tol' 
insert into @geovindu select N'囲','tong' 
insert into @geovindu select N'偷','tou' 
insert into @geovindu select N'凸','tu' 
insert into @geovindu select N'湍','tuan' 
insert into @geovindu select N'推','tui' 
insert into @geovindu select N'旽','tun' 
insert into @geovindu select N'乇','tuo' 
insert into @geovindu select N'屲','wa' 
insert into @geovindu select N'歪','wai' 
insert into @geovindu select N'乛','wan' 
insert into @geovindu select N'尣','wang' 
insert into @geovindu select N'危','wei' 
insert into @geovindu select N'塭','wen' 
insert into @geovindu select N'翁','weng' 
insert into @geovindu select N'挝','wo' 
insert into @geovindu select N'乌','wu' 
insert into @geovindu select N'夕','xi' 
insert into @geovindu select N'诶','ei' 
insert into @geovindu select N'疨','xia' 
insert into @geovindu select N'仙','xian' 
insert into @geovindu select N'乡','xiang' 
insert into @geovindu select N'灱','xiao' 
insert into @geovindu select N'楔','xie' 
insert into @geovindu select N'心','xin' 
insert into @geovindu select N'星','xing' 
insert into @geovindu select N'凶','xiong' 
insert into @geovindu select N'休','xiu' 
insert into @geovindu select N'旴','xu' 
insert into @geovindu select N'昍','xuan' 
insert into @geovindu select N'疶','xue' 
insert into @geovindu select N'坃','xun' 
insert into @geovindu select N'丫','ya' 
insert into @geovindu select N'咽','yan' 
insert into @geovindu select N'欕','eom' 
insert into @geovindu select N'央','yang' 
insert into @geovindu select N'涂','tu' 
insert into @geovindu select N'聚','ju' 
insert into @geovindu select N'文','wen' 
insert into @geovindu select N'吆','yao' 
insert into @geovindu select N'椰','ye' 
insert into @geovindu select N'膶','yen' 
insert into @geovindu select N'一','yi' 
insert into @geovindu select N'乁','i' 
insert into @geovindu select N'乚','yin' 
insert into @geovindu select N'应','ying' 
insert into @geovindu select N'哟','yo' 
insert into @geovindu select N'佣','yong' 
insert into @geovindu select N'优','you' 
insert into @geovindu select N'迂','yu' 
insert into @geovindu select N'囦','yuan' 
insert into @geovindu select N'曰','yue' 
insert into @geovindu select N'蒀','yun' 
insert into @geovindu select N'帀','za' 
insert into @geovindu select N'災','zai' 
insert into @geovindu select N'兂','zan' 
insert into @geovindu select N'牂','zang' 
insert into @geovindu select N'遭','zao' 
insert into @geovindu select N'啫','ze' 
insert into @geovindu select N'贼','zei' 
insert into @geovindu select N'怎','zen' 
insert into @geovindu select N'曽','zeng' 
insert into @geovindu select N'吒','zha' 
insert into @geovindu select N'甴','gad' 
insert into @geovindu select N'夈','zhai' 
insert into @geovindu select N'毡','zhan' 
insert into @geovindu select N'张','zhang' 
insert into @geovindu select N'钊','zhao' 
insert into @geovindu select N'蜇','zhe' 
insert into @geovindu select N'贞','zhen' 
insert into @geovindu select N'凧','zheng' 
insert into @geovindu select N'之','zhi' 
insert into @geovindu select N'中','zhong' 
insert into @geovindu select N'州','zhou' 
insert into @geovindu select N'劯','zhu' 
insert into @geovindu select N'抓','zhua' 
insert into @geovindu select N'专','zhuan' 
insert into @geovindu select N'转','zhuai' 
insert into @geovindu select N'妆','zhuang' 
insert into @geovindu select N'骓','zhui' 
insert into @geovindu select N'宒','zhun' 
insert into @geovindu select N'卓','zhuo' 
insert into @geovindu select N'孜','zi' 
insert into @geovindu select N'唨','zo' 
insert into @geovindu select N'宗','zong' 
insert into @geovindu select N'棸','zou' 
insert into @geovindu select N'哫','zu' 
insert into @geovindu select N'劗','zuan' 
insert into @geovindu select N'厜','zui' 
insert into @geovindu select N'尊','zun' 
insert into @geovindu select N'昨','zuo' 
insert into @geovindu select N'孙','sun' 
insert into @geovindu select N'斯','si' 

declare @strlen int 
select @strlen=len(@str),@re='' 
while @strlen>0 
begin 
select top 1 @re=UPPER(substring(py,1,1) )+substring(py,2,len(py))+@re,@strlen=@strlen-1 
from @geovindu a where chr<=substring(@str,@strlen,1) 
order by chr collate Chinese_PRC_CS_AS_KS_WS desc 
if @@rowcount=0 
select @re=substring(@str,@strlen,1)+@re,@strlen=@strlen-1 
end 
return(@re) 
end 
GO 


測試代碼如下: 

--測試在功(其它应用于可想而知了,这里不多说了) 
SELECT dbo.f_GetPy('人昨涂聚文宗斯博') as '拼音' 
GO 

測試代碼如下: 

--測試在功(其它应用于可想而知了,这里不多说了) 
SELECT dbo.f_GetPy('人昨涂聚文涂斯博') as '拼音' 
GO 

GO

延伸 · 阅读

精彩推荐