SQL obtains the whole spelling code according to Chinese character _mssql

Source: Internet
Author: User
Tags chr strlen
Copy Code code as follows:



/*


SQL based on Chinese characters to get full spell (some words have not been added up, please add yourself, tu Note)


Generate all temporary tables for pronunciation


Get pronunciation according to Chinese_prc_cs_as_ks_ws sort


Geovindu@163.com 2009-12-2 Other features please discuss, I am in the complex environment test, simple will be more convenient.


*/


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)


--Generate temporary tables


--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 ' acridine ', ' a '


Insert INTO @geovindu select N ' 厑 ', ' AES '


Insert INTO @geovindu select N ' eh ', ' ai '


Insert INTO @geovindu select N ' ann ', ' an '


Insert INTO @geovindu select N ' Clean ', ' ang '


Insert INTO @geovindu select N ' concave ', ' ao '


Insert INTO @geovindu select N ' Eight ', ' BA '


Insert INTO @geovindu select N ' 挀 ', ' Bai '


Insert INTO @geovindu select N ' 兡 ', ' baike '


Insert INTO @geovindu select N ' 瓸 ', ' Baiwa '


Insert INTO @geovindu select N ' wrench ', ' ban '


Insert INTO @geovindu select N ' bang ', ' bang '


Insert INTO @geovindu select N ' 勹 ', ' Bao '


Insert INTO @geovindu select N ' 萡 ' and ' be '


Insert INTO @geovindu select N ' po ', ' bei '


Insert INTO @geovindu select N ' Ben ', ' Ben '


Insert INTO @geovindu select N ' 伻 ', ' Beng '


Insert INTO @geovindu select N ' saponin ', ' bi '


Insert INTO @geovindu select N ' Edge ', ' Bian '


Insert INTO @geovindu select N ' 辪 ', ' UU '


Insert INTO @geovindu select N ' Know ', ' Biao '


Insert INTO @geovindu select N ' Suppress ', ' 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 ' Cha ', ' CA '


Insert INTO @geovindu select N ' moustached ', ' Cai '


Insert INTO @geovindu select N ' 乲 ', ' Cal '


Insert INTO @geovindu select N ' parameters ', ' Can '


Insert INTO @geovindu select N ' Cang ', ' Cang '


Insert INTO @geovindu select N ' 撡 ', ' Cao '


Insert INTO @geovindu select N ' brochure ', ' CE '


Insert INTO @geovindu select N ' 膥 ', ' cen '


Insert INTO @geovindu select N ' miso ', ' 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 ' fork ', ' Cha '


Insert INTO @geovindu select N ' 犲 ', ' Chai '


Insert INTO @geovindu select N ' 辿 ', ' Chan '


Insert INTO @geovindu select N ' 伥 ', ' Chang '


Insert INTO @geovindu select N ' Copy ', ' Chao '


Insert INTO @geovindu select N ' car ', ' che '


Insert INTO @geovindu select N ' straighten ', ' Chen '


Insert INTO @geovindu select N ' 阷 ', ' Cheng '


Insert INTO @geovindu select N ' eat ', ' chi '


Insert INTO @geovindu select N ' charge ', ' Chong '


Insert INTO @geovindu select N ' Smoke ', ' Chou '


Insert INTO @geovindu select N ' Out ', ' Chu '


Insert INTO @geovindu select N ' 膗 ', ' Chuai '


Insert INTO @geovindu select N ' 巛 ', ' Chuan '


Insert INTO @geovindu select N ' 刅 ', ' Chuang '


Insert INTO @geovindu select N ' blow ', ' chui '


Insert INTO @geovindu select N ' 旾 ', ' Chun '


Insert INTO @geovindu select N ' 踔 ', ' Chuo '


Insert INTO @geovindu select N ' bared ', ' CI '


Insert INTO @geovindu select N ' 嗭 ', ' CIS '


Insert INTO @geovindu select N ' from ', ' Cong '


Insert INTO @geovindu select N ' Scrape ', ' cou '


Insert INTO @geovindu select N ' thick ', ' cu '


Insert INTO @geovindu select N ' boil ', ' Cuan '


Insert INTO @geovindu select N ' cui ', ' cui '


Insert INTO @geovindu select N ' Estate ', ' Cun '


Insert INTO @geovindu select N ' 瑳 ', ' CuO '


Insert INTO @geovindu select N ' pinch ', ' Chua '


Insert INTO @geovindu select N ' 咑 ', ' da '


Insert INTO @geovindu select N ' tie ', ' Dai '


Insert INTO @geovindu select N ' Dan ', ' Dan '


Insert INTO @geovindu select N ' when ', ' Dang '


Insert INTO @geovindu select N ' Knife ', ' DAO '


Insert INTO @geovindu select N ' Rusty ', ' de '


Insert INTO @geovindu select N ' Scissors ', ' dem '


Insert INTO @geovindu select N ' consignor ', ' den '


Insert INTO @geovindu select N ' lamp ', ' Deng '


Insert INTO @geovindu select N ' 仾 ', ' di '


Insert INTO @geovindu select N ' whine ', ' dia '


Insert INTO @geovindu select N ' 敁 ', ' Dian '


Insert INTO @geovindu select N ' Diao ', ' Diao '


Insert INTO @geovindu select N ' Daddy ', ' die '


Insert INTO @geovindu Select N ' we ', ' dei '


Insert INTO @geovindu select N ' 嚸 ', ' dim '


Insert INTO @geovindu select N ' d ', ' ding '


Insert INTO @geovindu select N ' drop ', ' Diu '


Insert INTO @geovindu select N ' East ', ' 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 ' t ', ' dun '


Insert INTO @geovindu select N ' duh ', ' duo '


Insert INTO @geovindu select N ' 妸 ', ' e '


Insert INTO @geovindu select N ' en ', ' 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 ', ' er '


Insert INTO @geovindu select N ' send ', ' FA '


Insert INTO @geovindu select N ' sail ', ' fan '


Insert INTO @geovindu select N ' 匚 ', ' Fang '


Insert INTO @geovindu select N ' Fly ', ' Fei '


Insert INTO @geovindu select N ' thiophene ', ' fen '


Insert INTO @geovindu select N ' abundance ', ' 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 ' husband ', ' Fu '


Insert INTO @geovindu select N ' 猤 ', ' Fui '


Insert INTO @geovindu select N ' there ', ' GA '


Insert INTO @geovindu select N ' 侅 ', ' Gai '


Insert INTO @geovindu select N ' gan ', ' gan '


Insert INTO @geovindu select N ' Gang ', ' gang '


Insert INTO @geovindu select N ' Gao ', ' Gao '


Insert INTO @geovindu select N ' gore ', ' ge '


Insert INTO @geovindu select N ' Give ', ' GEi '


Insert INTO @geovindu select N ' root ', ' gen '


Insert INTO @geovindu select N ' More ', ' Geng '


Insert INTO @geovindu select N ' 啹 ', ' Geu '


Insert INTO @geovindu select N ' snap ', ' Gib '


Insert INTO @geovindu select N ' i ', ' go '


Insert INTO @geovindu select N ' work ', ' gong '


Insert INTO @geovindu select N ' 兝 ', ' Gongfen '


Insert INTO @geovindu select N ' 兣 ', ' Gongli '


Insert INTO @geovindu select N ' tick ', ' Gou '


Insert INTO @geovindu select N ' estimate ', ' gu '


Insert INTO @geovindu select N ' melon ', ' gua '


Insert INTO @geovindu select N ' well-behaved ', ' Guai '


Insert INTO @geovindu select N ' off ', ' Guan '


Insert INTO @geovindu select N ' Light ', ' Guang '


Insert INTO @geovindu select N ' return ', ' GUI '


Insert INTO @geovindu select N ' 丨 ', ' gun '


Insert INTO @geovindu select N ' Kuai ', ' 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 ' Chekhov ', ' he '


Insert INTO @geovindu select N ' Black ', ' hei '


Insert INTO @geovindu Select N ' categorically pointed out ', ' hen '


Insert INTO @geovindu select N ' Heng ', ' Heng '


Insert INTO @geovindu select N ' Double Happiness ', ' heui '


Insert INTO @geovindu select N ' remainders ', ' ho '


Insert INTO @geovindu select N ' 乥 ', ' hol '


Insert INTO @geovindu select N ' 叿 ', ' the '


Insert INTO @geovindu select N ' 齁 ', ' hou '


Insert INTO @geovindu select N ' o ', ' Hu '


Insert INTO @geovindu select N ' Flower ', ' hua '


Insert INTO @geovindu select N ' irresolute ', ' Huai '


Insert INTO @geovindu select N ' Huan ', ' Huan '


Insert INTO @geovindu select N ' dumplings ', ' Huang '


Insert INTO @geovindu select N ' Ash ', ' hui '


Insert INTO @geovindu select N ' faint ', ' hun '


Insert INTO @geovindu select N ' 吙 ', ' Huo '


Insert INTO @geovindu select N ' 嚿 ', ' Geo '


Insert INTO @geovindu select N ' 夻 ', ' hwa '


Insert INTO @geovindu select N ' No ', ' Ji '


Insert INTO @geovindu select N ' Plus ', ' Jia '


Insert INTO @geovindu select N ' 嗧 ', ' Jialun '


Insert INTO @geovindu select N ' 戋 ', ' Jian '


Insert INTO @geovindu select N ' Jiang ', ' Jiang '


Insert INTO @geovindu select N ' Qiu ', ' jiao '


Insert INTO @geovindu Select N ' Order ', ' Jie '


Insert INTO @geovindu select N ' Towel ', ' 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 ' pout ', ' Jue '


Insert INTO @geovindu select N ' Army ', ' June '


Insert INTO @geovindu select N ' click ', ' ka '


Insert INTO @geovindu Select N ' Open ', ' Kai '


Insert INTO @geovindu select N ' 乫 ', ' Kal '


Insert INTO @geovindu select N ' Journal ', ' kan '


Insert INTO @geovindu select N ' kan ', ' hem '


Insert INTO @geovindu select N ' 砊 ', ' Kang '


Insert INTO @geovindu select N ' kao ', ' Kao '


Insert INTO @geovindu select N ' ke ', ' 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 ' Micky ', ' Ki '


Insert INTO @geovindu select N ' empty ', ' Kong '


Insert INTO @geovindu select N ' 廤 ', ' Kos '


Insert INTO @geovindu select N ' pull ', ' Kou '


Insert INTO @geovindu select N ' 扝 ', ' ku '


Insert INTO @geovindu select N ' Kua ', ' Kua '


Insert INTO @geovindu select N ' Quine ', ' Kuai '


Insert INTO @geovindu select N ' width ', ' Kuan '


Insert INTO @geovindu select N ' Marina ', ' Kuang '


Insert INTO @geovindu select N ' deficient ', ' Kui '


Insert INTO @geovindu select N ' kun ', ' kun '


Insert INTO @geovindu select N ' Hiroki ', ' Kuo '


Insert INTO @geovindu select N ' 穒 ', ' Kweok '


Insert INTO @geovindu select N ' garbage ', ' La '


Insert INTO @geovindu Select N ' Come ', ' Lai '


Insert INTO @geovindu select N ' LAN ', ' LAN '


Insert INTO @geovindu select N ' Lang '.


Insert INTO @geovindu select N ' fished ', ' Lao '


Insert INTO @geovindu select N ' Le ', ' le '


Insert INTO @geovindu select N ' Thunder ', ' lei '


Insert INTO @geovindu select N ' Leng ', ' Leng '


Insert INTO @geovindu select N ' ye ', ' li '


Insert INTO @geovindu select N ' two ', ' 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 ', ' Ling '


Insert INTO @geovindu select N ' Sneak ', ' Liu '


Insert INTO @geovindu select N ' 瓼 ', ' Liwa '


Insert INTO @geovindu select N ' 囖 ', ' lo '


Insert INTO @geovindu select N ' Dragon ', ' long '


Insert INTO @geovindu select N ' Lou ', ' Lou '


Insert INTO @geovindu select N ' chatter ', ' LU '


Insert INTO @geovindu select N ' Donkey ', ' LV '


Insert INTO @geovindu select N ' 寽 ', ' Lue '


Insert INTO @geovindu select N ' twin ', ' Luan '


Insert INTO @geovindu select N ' stall ', ' LUN '


Insert INTO @geovindu select N ' 頱 ', ' Luo '


Insert INTO @geovindu select N ' hmm ', ' m '


Insert INTO @geovindu select N ' ma ', ' ma '


Insert INTO @geovindu select N ' 遤 ', ' Hweong '


Insert INTO @geovindu select N ' Bury ', ' Mai '


Insert INTO @geovindu select N ' 颟 ', ' Mans '


Insert INTO @geovindu select N ' Mang ', ' Mang '


Insert INTO @geovindu select N ' monme ', ' Mangmi '


Insert INTO @geovindu select N ' cat ', ' 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 ' Smiling ', ' mi '


Insert INTO @geovindu select N ' coinage ', ' mian '


Insert INTO @geovindu select N ' Meow ', ' Miao '


Insert INTO @geovindu select N ' What ', ' mie '


Insert INTO @geovindu select N ' 瓱 ', ' miliklanm '


Insert INTO @geovindu select N ' min ', ' min '


Insert INTO @geovindu select N ' 冧 ', ' Lem '


Insert INTO @geovindu select N ' name ', ' Ming '


Insert INTO @geovindu select N ' fallacy ', ' Miu '


Insert INTO @geovindu select N ' Touch ', ' Mo '


Insert INTO @geovindu select N ' 乮 ', ' mol '


Insert INTO @geovindu select N ' Moo ', ' MoU '


Insert INTO @geovindu Select N ' mother ', ' mu '


Insert INTO @geovindu select N ' temperature ', ' 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 ' Nam ', ' nan '


Insert INTO @geovindu select N ' tumult ', ' Nang '


Insert INTO @geovindu select N ' 乪 ', ' keg '


Insert INTO @geovindu select N ' No ', ' Nao '


Insert INTO @geovindu Select N ' non-epileptic seizure ', ' ne '


Insert INTO @geovindu select N ' 娞 ', ' nei '


Insert INTO @geovindu select N ' 焾 ', ' nem '


Insert INTO @geovindu select N ' Tender ', ' nen '


Insert INTO @geovindu select N ' 莻 ', ' Neus '


Insert INTO @geovindu select N ' 鈪 ', ' Ngag '


Insert INTO @geovindu select N ' 銰 ', ' Ngai '


Insert INTO @geovindu select N ' Stop ', ' Ngam '


Insert INTO @geovindu select N ' Nicole ', ' ni '


Insert INTO @geovindu Select N ' year ', ' Nian '


Insert INTO @geovindu select N ' Niang ', ' Niang '


Insert INTO @geovindu select N ' Tsutaichi ', ' Niao '


Insert INTO @geovindu select N ' pinch ', ' nie '


Insert INTO @geovindu select N ' 脌 ', ' nin '


Insert INTO @geovindu select N ' ning ', ' Ning '


Insert INTO @geovindu select N ' ox ', ' niu '


Insert INTO @geovindu select N ' Nong ', ' Nong '


Insert INTO @geovindu select N ' 羺 ', ' Nou '


Insert INTO @geovindu select N ' slave ', ' Nu '


Insert INTO @geovindu select N ' Female ', ' NV '


Insert INTO @geovindu select N ' Malaria ', ' nue '


Insert INTO @geovindu select N ' Malaria ', ' nve '


Insert INTO @geovindu select N ' 奻 ', ' Nuan '


Insert INTO @geovindu select N ' 黁 ', ' Nun '


Insert INTO @geovindu select N ' 燶 ', ' Nung '


Insert INTO @geovindu select N ' move ', ' nuo '


Insert INTO @geovindu select N ' 筽 ', ' O '


Insert INTO @geovindu select N ' 夞 ', ' oes '


Insert INTO @geovindu select N ' 乯 ', ' ol '


Insert INTO @geovindu select N ' 鞰 ' and ' on '


Insert INTO @geovindu select N ' 讴 ', ' ou '


Insert INTO @geovindu select N ' 妑 ', ' pa '


Insert INTO @geovindu select N ' petaline ', ' pai '


Insert INTO @geovindu select N ' 磗 ', ' Pak '


Insert INTO @geovindu select N ' 眅 ', ' Pan '


Insert INTO @geovindu select N ' Pong ', ' Pang '


Insert INTO @geovindu select N ' throw ', ' pao '


Insert INTO @geovindu select N ' Pooh ', ' 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 '


Inserts into @geovindu select N ' pi ', ' pi '


Insert INTO @geovindu select N ' 囨 ', ' Pian '


Insert INTO @geovindu select N ' ectoplasms ', ' Piao '


Insert INTO @geovindu select N ' protium ', ' Pie '


Insert INTO @geovindu select N ' in Heart ', ' Pianpang '


Insert INTO @geovindu Select N ' meteorological ', ' pin '


Insert INTO @geovindu select N ' pings ', ' ping '


Insert INTO @geovindu select N ' Plutonium ', ' po '


Insert INTO @geovindu select N ' profile ', ' Pou '


Insert INTO @geovindu select N ' 哣 ', ' Deo '


Insert INTO @geovindu select N ' 兺 ', ' ppun '


Insert INTO @geovindu select N ' servant ', ' pu '


Insert INTO @geovindu Select N ' Seven ', ' Qi '


Insert INTO @geovindu select N ' pinch ', ' QIA '


Insert INTO @geovindu select N ' thousand ', ' Qian '


Insert INTO @geovindu select N ' Qiang ', ' Qiang '


Insert INTO @geovindu select N ' 兛 ', ' Qianke '


Insert INTO @geovindu select N ' kw ', ' Qianwa '


Insert INTO @geovindu select N ' Qiao ', ' Qiao '


Insert INTO @geovindu select N ' 苆 ', ' Qie '


Insert INTO @geovindu select N ' Pro ', ' Qin '


Insert INTO @geovindu select N ' 蠄 ', ' Kem '


Insert INTO @geovindu select N ' hydrogen ', ' Qing '


Insert INTO @geovindu select N ' 銎 ', ' Qiong '


Insert INTO @geovindu select N ' Mound ', ' Qiu '


Insert INTO @geovindu select N ' song ', ' 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 ' Everybody ', ' 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 ' provoke ', ' re '


Insert INTO @geovindu select N ' person ', ' ren '


Insert INTO @geovindu select N ' throw ', ' Reng '


Insert INTO @geovindu select N ' Day ', ' ri '


Insert INTO @geovindu select N ' 栄 ', ' Rong '


Insert INTO @geovindu select N ' 禸 ', ' Rou '


Insert INTO @geovindu select N ' 嶿 ', ' ru '


Insert INTO @geovindu select N ' Device ', ' Ruan '


Insert INTO @geovindu select N ' 桵 ', ' Rui '


Insert INTO @geovindu select N ' Leap ', ' run '


Insert INTO @geovindu select N ' 叒 ', ' Ruo '


Insert INTO @geovindu select N ' Three ', ' sa '


Insert INTO @geovindu select N ' 栍 ', ' Saeng '


Insert INTO @geovindu select N ' 毢 ', ' Sai '


Insert INTO @geovindu select N ' 虄 ', ' Sal '


Insert INTO @geovindu select N ' Three ', ' San '


Insert INTO @geovindu select N ' 桒 ', ' sang '


Insert INTO @geovindu select N ' 掻 ', ' Sao '


Insert INTO @geovindu select N ' color ', ' se '


Insert INTO @geovindu Select N '-shirt ', ' sed '


Insert INTO @geovindu select N ' 聓 ', ' sei '


Insert INTO @geovindu Select N ' sen ', ' Sen '


Insert INTO @geovindu select N ' 鬙 ', ' Seng '


Insert INTO @geovindu select N ' 閪 ', ' seo '


Insert INTO @geovindu select N ' 縇 ', ' Seon '


Insert INTO @geovindu select N ' Kill ', ' Sha '


Insert INTO @geovindu select N ' Sieve ', ' shai '


Insert INTO @geovindu select N ' Mountain ', ' Shan '


Insert INTO @geovindu select N ' hurt ', ' Shang '


Insert INTO @geovindu select N ' 弰 ', ' Shao '


Insert INTO @geovindu select N ' extravagance ', ' she '


Insert INTO @geovindu select N ' Shen ', ' Shen '


Insert INTO @geovindu select N ' l ', ' Sheng '


Insert INTO @geovindu select N ' Corpse ', ' shi '


Insert INTO @geovindu select N ' 兙 ', ' shike '


Insert INTO @geovindu select N ' 瓧 ', ' Shiwa '


Insert INTO @geovindu select N ' Survival ', ' Shou '


Insert INTO @geovindu select N ' book ', ' Shu '


Insert INTO @geovindu select N ' Brush ', ' Shua '


Insert INTO @geovindu select N ' Fall ', ' Shuai '


Insert INTO @geovindu select N ' latch ', ' Shuan '


Insert INTO @geovindu select N ' Double ', ' Shuang '


Insert INTO @geovindu select N ' who ', ' Shei '


Insert INTO @geovindu select N ' 脽 ', ' Shui '


Insert INTO @geovindu select N ' suck ', ' shun '


Insert INTO @geovindu select N ' 哾 ', ' Shuo '


Insert INTO @geovindu select N ' Silk ', ' si '


Insert INTO @geovindu select N ' guarding ', ' so '


Insert INTO @geovindu select N ' 乺 ', ' Sol '


Insert INTO @geovindu select N ' 忪 ', ' song '


Insert INTO @geovindu select N ' 凁 ', ' sou '


Insert INTO @geovindu select N ' Sue ', ' su '


Insert INTO @geovindu select N ' acids ', ' Suan '


Insert INTO @geovindu select N ' 夊 ', ' sui '


Insert INTO @geovindu select N ' suo ', ' suo '


Insert INTO @geovindu select N ' he ', ' ta '


Insert INTO @geovindu select N ' 襨 ', ' tae '


Insert INTO @geovindu select N ' 囼 ', ' Tai '


Insert INTO @geovindu select N ' collapse ', ' tan '


Insert INTO @geovindu select N ' 铴 ', ' Tang '


Insert INTO @geovindu select N ' 仐 ', ' Tao '


Insert INTO @geovindu select N ' 畓 ', ' tap '


Insert INTO @geovindu select N ' It ', ' te '


Insert INTO @geovindu select N ' 膯 ', ' Teng '


Insert INTO @geovindu select N ' 唞 ', ' Teo '


Insert INTO @geovindu select N ' 朰 ', ' Teul '


Insert INTO @geovindu select N ' tick ', ' ti '


Insert INTO @geovindu select N ' Day ', ' Tian '


Insert INTO @geovindu select N ' 旫 ', ' Tiao '


Insert INTO @geovindu select N ' 怗 ', ' tie '


Insert INTO @geovindu select N ' Hall ', ' Ting '


Insert INTO @geovindu select N ' 乭 ', ' tol '


Insert INTO @geovindu select N ' 囲 ', ' Tong '


Insert INTO @geovindu select N ' Steal ', ' tou '


Insert INTO @geovindu select N ' convex ', ' tu '


Insert INTO @geovindu select N ' turbulence ', ' Tuan '


Insert INTO @geovindu select N ' push ', ' TUI '


Insert INTO @geovindu select N ' dozing ', ' tun '


Insert INTO @geovindu select N ' Torr ', ' Tuo '


Insert INTO @geovindu select N ' 屲 ', ' WA '


Insert INTO @geovindu select N ' skew ', ' Wai '


Insert INTO @geovindu select N ' 乛 ', ' Wan '


Insert INTO @geovindu select N ' 尣 ', ' Wang '


Insert INTO @geovindu Select N ' crisis ', ' Wei '


Insert INTO @geovindu select N ' Ponds ', ' wen '


Insert INTO @geovindu select N ' Weng ', ' Weng '


Insert INTO @geovindu select N ' i ', ' wo '


Insert INTO @geovindu select N ' Wu ', ' Wu '


Insert INTO @geovindu select N ' Eve ', ' XI '


Insert INTO @geovindu select N ' eh ', ' ei '


Insert INTO @geovindu select N ' 疨 ', ' Xia '


Insert INTO @geovindu select N ' Fairy ', ' Xian '


Insert INTO @geovindu select N ' Heung ', ' Xiang '


Insert INTO @geovindu select N ' 灱 ', ' Xiao '


Insert INTO @geovindu select N ' Wedge ', ' Xie '


Insert INTO @geovindu select N ' heart ', ' Xin '


Insert INTO @geovindu select N ' star ', ' Xing '


Insert INTO @geovindu select N ' Fierce ', ' Xiong '


Insert INTO @geovindu select N ' Hugh ', ' Xiu '


Insert INTO @geovindu select N ' Bion ', ' 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 ', ' ya '


Insert INTO @geovindu select N ' Swallow ', ' Yan '


Insert INTO @geovindu select N ' 欕 ', ' EOM '


Insert INTO @geovindu select N ' epicenter ', ' yang '


Insert INTO @geovindu select N ' smear ', ' tu '


Insert INTO @geovindu select N ' Poly ', ' ju '


Insert INTO @geovindu select N ' Wen ', ' Wen '


Insert INTO @geovindu select N ' Yo ', ' Yao '


Insert INTO @geovindu select N ' coconut ', ' ye '


Insert INTO @geovindu select N ' 膶 ', ' yen '


Insert INTO @geovindu select N ' One ', ' Yi '


Insert INTO @geovindu select N ' 乁 ', ' I '


Insert INTO @geovindu select N ' 乚 ', ' Yin '


Insert INTO @geovindu select N ' shall ', ' Ying '


Insert INTO @geovindu select N ' yo ', ' Yo '


Insert INTO @geovindu select N ' Maid ', ' Yong '


Insert INTO @geovindu select N ' excellent ', ' you '


Insert INTO @geovindu select N ' circuitous ', ' Yu '


Insert INTO @geovindu select N ' continents ', ' yuan '


Insert INTO @geovindu select N ' Yue ', ' Yue '


Insert INTO @geovindu select N ' 蒀 ', ' Yun '


Insert INTO @geovindu select N ' 帀 ', ' za '


Insert INTO @geovindu select N ' Cataclysm ', ' Zai '


Insert INTO @geovindu select N ' 兂 ', ' Zan '


Insert INTO @geovindu select N ' 牂 ', ' Zang '


Insert INTO @geovindu select N ' suffer ', ' Zao '


Insert INTO @geovindu select N ' Jelly ', ' ze '


Insert INTO @geovindu select N ' thief ', ' Zei '


Insert INTO @geovindu Select N ' How ', ' Zen '


Insert INTO @geovindu select N ' 'd ', ' Zeng '


Insert INTO @geovindu select N ' upbraid ', ' Zha '


Insert INTO @geovindu select N ' 甴 ', ' Gad '


Insert INTO @geovindu select N ' 夈 ', ' Zhai '


Insert INTO @geovindu Select N ' felt ', ' Zhan '


Insert INTO @geovindu select N ' Zhang ', ' Zhang '


Insert INTO @geovindu select N ' Chiu ', ' Zhao '


Insert INTO @geovindu select N ' sting ', ' Zhe '


Insert INTO @geovindu select N ' Jeong ', ' zhen '


Insert INTO @geovindu select N ' 凧 ', ' Zheng '


Insert INTO @geovindu select N ' ', ' zhi '


Insert INTO @geovindu select N ' Middle ', ' Zhong '


Insert INTO @geovindu select N ' state ', ' Zhou '


Insert INTO @geovindu select N ' 劯 ', ' Zhu '


Insert INTO @geovindu select N ' catch ', ' Zhua '


Insert INTO @geovindu select N ' Special ', ' Zhuan '


Insert INTO @geovindu Select N ' Turn ', ' Zhuai '


Insert INTO @geovindu select N ' Makeup ', ' Zhuang '


Insert INTO @geovindu select N ' 骓 ', ' Zhui '


Insert INTO @geovindu select N ' 宒 ', ' Zhun '


Insert INTO @geovindu select N ' Zhuo ', ' Zhuo '


Insert INTO @geovindu select N ' cumin ', ' zi '


Insert INTO @geovindu select N ' 唨 ', ' zo '


Insert INTO @geovindu select N ' Zong ', ' Zong '


Insert INTO @geovindu select N ' 棸 ', ' Zou '


Insert INTO @geovindu select N ' 哫 ', ' zu '


Insert INTO @geovindu select N ' 劗 ', ' Zuan '


Insert INTO @geovindu select N ' Ricoh ', ' Zui '


Insert INTO @geovindu select N ' Zun ', ' Zun '


Insert INTO @geovindu select N ' Yesterday ', ' Zuo '


Insert INTO @geovindu select N ' Sun ', ' 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





Test codes are as follows:





-Test in the work (other applications are conceivable, here is not much to say)


SELECT dbo.f_getpy (' People yesterday painted Poly Venzonsbo ') as ' pinyin '


Go





Test codes are as follows:





-Test in the work (other applications are conceivable, here is not much to say)


SELECT dbo.f_getpy (' People yesterday painted Poly Glespor ') as ' pinyin '


Go





Go

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.