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