宿州市住房 建设 官方网站,wordpress如何修改字体大小,电商网站有什么,大连做网站的作用#xff1a; 将汉字生成为全拼音或者首字母#xff0c;示例
执行自定义函数#xff0c;将汉字转成对应的首字母 执行自定义函数#xff0c;将汉字转成全拼音 自定义教程#xff1a; 一#xff0c;只取汉字的首字母 代码如下#xff1a; 执行下面sql 就自定义函数了…作用 将汉字生成为全拼音或者首字母示例
执行自定义函数将汉字转成对应的首字母 执行自定义函数将汉字转成全拼音 自定义教程 一只取汉字的首字母 代码如下 执行下面sql 就自定义函数了
View Code
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
goCREATE FUNCTION [dbo].[fun_getPY](str nvarchar(4000) )
RETURNS nvarchar(4000)
AS
BEGIN DECLARE word nchar(1),PY nvarchar(4000) set PY WHILE len(str)0 BEGIN set wordleft(str,1) --如果非汉字字符返回原字符 set PYPY(case when unicode(word) between 19968 and 1996820901 then ( select top 1 PY from ( select A as PY,N驁 as word union all select B,N簿 union all select C,N錯 union all select D,N鵽 union all select E,N樲 union all select F,N鰒 union all select G,N腂 union all select H,N夻 union all select J,N攈 union all select K,N穒 union all select L,N鱳 union all select M,N旀 union all select N,N桛 union all select O,N漚 union all select P,N曝 union all select Q,N囕 union all select R,N鶸 union all select S,N蜶 union all select T,N籜 union all select W,N鶩 union all select X,N鑂 union all select Y,N韻 union all select Z,N咗 ) T where wordword collate Chinese_PRC_CS_AS_KS_WS order by PY ASC ) else word end) SET strright(str,len(str)-1) END RETURN PY
END GOSELECT dbo.fun_getPY(来1吧)
执行完上面sql,执行下面
SELECT dbo.fun_getPY(来1吧)-- 得到L1B
二另一种是取汉字胡全拼 代码如下
CREATE function [dbo].[fn_GetPinyin](words nVARCHAR(2000))
RETURNS VARCHAR(8000)
AS BEGIN DECLARE word nchar(1) DECLARE pinyin VARCHAR(8000) DECLARE i INTDECLARE words_len INTDECLARE unicode INTSET i 1 SET words ltrim(rtrim(words)) SET words_len len(words) WHILE(i words_len)--循环取字符BEGIN SET word substring(words, i, 1) SET unicode unicode(word) SET pinyin ISNULL(pinyin SPACE(1),) (CASE WHEN unicode(word)between 19968 and 1996820901 then (SELECT TOP 1 py FROM ( SELECTaAS py,N厑AS word UNION ALL SELECT ai,N靉UNION ALL SELECTan,N黯UNION ALL SELECTang,N醠UNION ALL SELECTao,N驁UNION ALL SELECTba,N欛UNION ALL SELECTbai,N瓸--韛兡瓸UNION ALL SELECTban,N瓣UNION ALL SELECTbang,N鎊UNION ALL SELECTbao,N鑤UNION ALL SELECTbei,N鐾UNION ALL SELECTben,N輽UNION ALL SELECTbeng,N鏰UNION ALL SELECTbi,N鼊UNION ALL SELECTbian,N變UNION ALL SELECTbiao,N鰾UNION ALL SELECTbie,N彆UNION ALL SELECTbin,N鬢UNION ALL SELECTbing,N靐UNION ALL SELECTbo,N蔔UNION ALL SELECTbu,N簿UNION ALL SELECTca,N囃UNION ALL SELECTcai,N乲--縩乲UNION ALL SELECTcan,N爘UNION ALL SELECTcang,N賶UNION ALL SELECTcao,N鼜UNION ALL SELECTce,N簎UNION ALL SELECTcen,N笒UNION ALL SELECTceng,N乽--硛硳岾猠乽UNION ALL SELECTcha,N詫UNION ALL SELECTchai,N囆UNION ALL SELECTchan,N顫UNION ALL SELECTchang,N韔UNION ALL SELECTchao,N觘UNION ALL SELECTche,N爡UNION ALL SELECTchen,N讖UNION ALL SELECTcheng,N秤UNION ALL SELECTchi,N鷘UNION ALL SELECTchong,N銃UNION ALL SELECTchou,N殠UNION ALL SELECTchu,N矗UNION ALL SELECTchuai,N踹UNION ALL SELECTchuan,N鶨UNION ALL SELECTchuang,N愴UNION ALL SELECTchui,N顀UNION ALL SELECTchun,N蠢UNION ALL SELECTchuo,N縒UNION ALL SELECTci,N嗭--賜嗭UNION ALL SELECTcong,N謥UNION ALL SELECTcou,N輳UNION ALL SELECTcu,N顣UNION ALL SELECTcuan,N爨UNION ALL SELECTcui,N臎UNION ALL SELECTcun,N籿UNION ALL SELECTcuo,N錯UNION ALL SELECTda,N橽UNION ALL SELECTdai,N靆UNION ALL SELECTdan,N饏UNION ALL SELECTdang,N闣UNION ALL SELECTdao,N纛UNION ALL SELECTde,N的UNION ALL SELECTden,N扽UNION ALL SELECTdeng,N鐙UNION ALL SELECTdi,N螮UNION ALL SELECTdia,N嗲UNION ALL SELECTdian,N驔UNION ALL SELECTdiao,N鑃UNION ALL SELECTdie,N嚸--眰嚸UNION ALL SELECTding,N顁UNION ALL SELECTdiu,N銩UNION ALL SELECTdong,N霘UNION ALL SELECTdou,N鬭UNION ALL SELECTdu,N蠹UNION ALL SELECTduan,N叾--籪叾UNION ALL SELECTdui,N譵UNION ALL SELECTdun,N踲UNION ALL SELECTduo,N鵽UNION ALL SELECTe,N鱷UNION ALL SELECTen,N摁UNION ALL SELECTeng,N鞥UNION ALL SELECTer,N樲UNION ALL SELECTfa,N髮UNION ALL SELECTfan,N瀪UNION ALL SELECTfang,N放UNION ALL SELECTfei,N靅UNION ALL SELECTfen,N鱝UNION ALL SELECTfeng,N覅UNION ALL SELECTfo,N梻UNION ALL SELECTfou,N鴀UNION ALL SELECTfu,N猤--鰒猤UNION ALL SELECTga,N魀UNION ALL SELECTgai,N瓂UNION ALL SELECTgan,N灨UNION ALL SELECTgang,N戇UNION ALL SELECTgao,N鋯UNION ALL SELECTge,N獦UNION ALL SELECTgei,N給UNION ALL SELECTgen,N搄UNION ALL SELECTgeng,N堩--亙堩啹喼嗰UNION ALL SELECTgong,N兣--熕贑兝兣UNION ALL SELECTgou,N購UNION ALL SELECTgu,N顧UNION ALL SELECTgua,N詿UNION ALL SELECTguai,N恠UNION ALL SELECTguan,N鱹UNION ALL SELECTguang,N撗UNION ALL SELECTgui,N鱥UNION ALL SELECTgun,N謴UNION ALL SELECTguo,N腂UNION ALL SELECTha,N哈UNION ALL SELECThai,N饚UNION ALL SELECThan,N鶾UNION ALL SELECThang,N沆UNION ALL SELECThao,N兞UNION ALL SELECThe,N靏UNION ALL SELECThei,N嬒UNION ALL SELECThen,N恨UNION ALL SELECTheng,N堼--堼囍UNION ALL SELECThong,N鬨UNION ALL SELECThou,N鱟UNION ALL SELECThu,N鸌UNION ALL SELECThua,N蘳UNION ALL SELECThuai,N蘾UNION ALL SELECThuan,N鰀UNION ALL SELECThuang,N鎤UNION ALL SELECThui,N顪UNION ALL SELECThun,N諢UNION ALL SELECThuo,N夻UNION ALL SELECTji,N驥UNION ALL SELECTjia,N嗧UNION ALL SELECTjian,N鑳UNION ALL SELECTjiang,N謽UNION ALL SELECTjiao,N釂UNION ALL SELECTjie,N繲UNION ALL SELECTjin,N齽UNION ALL SELECTjing,N竸UNION ALL SELECTjiong,N蘔UNION ALL SELECTjiu,N欍UNION ALL SELECTju,N爠UNION ALL SELECTjuan,N羂UNION ALL SELECTjue,N钁UNION ALL SELECTjun,N攈UNION ALL SELECTka,N鉲UNION ALL SELECTkai,N乫--鎎乫UNION ALL SELECTkan,N矙UNION ALL SELECTkang,N閌UNION ALL SELECTkao,N鯌UNION ALL SELECTke,N騍UNION ALL SELECTken,N褃UNION ALL SELECTkeng,N鏗--巪乬唟厼怾UNION ALL SELECTkong,N廤UNION ALL SELECTkou,N鷇UNION ALL SELECTku,N嚳UNION ALL SELECTkua,N骻UNION ALL SELECTkuai,N鱠UNION ALL SELECTkuan,N窾UNION ALL SELECTkuang,N鑛UNION ALL SELECTkui,N鑎UNION ALL SELECTkun,N睏UNION ALL SELECTkuo,N穒UNION ALL SELECTla,N鞡UNION ALL SELECTlai,N籟UNION ALL SELECTlan,N糷UNION ALL SELECTlang,N唥UNION ALL SELECTlao,N軂UNION ALL SELECTle,N餎UNION ALL SELECTlei,N脷--嘞脷UNION ALL SELECTleng,N睖UNION ALL SELECTli,N瓈UNION ALL SELECTlia,N倆UNION ALL SELECTlian,N纞UNION ALL SELECTliang,N鍄UNION ALL SELECTliao,N瞭UNION ALL SELECTlie,N鱲UNION ALL SELECTlin,N轥--轥拎UNION ALL SELECTling,N炩UNION ALL SELECTliu,N咯--瓼甅囖咯UNION ALL SELECTlong,N贚UNION ALL SELECTlou,N鏤UNION ALL SELECTlu,N氇UNION ALL SELECTlv,N鑢UNION ALL SELECTluan,N亂UNION ALL SELECTlue,N擽UNION ALL SELECTlun,N論UNION ALL SELECTluo,N鱳UNION ALL SELECTma,N嘛UNION ALL SELECTmai,N霢UNION ALL SELECTman,N蘰UNION ALL SELECTmang,N蠎UNION ALL SELECTmao,N唜UNION ALL SELECTme,N癦--癦呅UNION ALL SELECTmei,N嚜UNION ALL SELECTmen,N們UNION ALL SELECTmeng,N霥--霿踎UNION ALL SELECTmi,N羃UNION ALL SELECTmian,N麵UNION ALL SELECTmiao,N廟UNION ALL SELECTmie,N鱴--鱴瓱UNION ALL SELECTmin,N鰵UNION ALL SELECTming,N詺UNION ALL SELECTmiu,N謬UNION ALL SELECTmo,N耱--耱乮UNION ALL SELECTmou,N麰--麰蟱UNION ALL SELECTmu,N旀UNION ALL SELECTna,N魶UNION ALL SELECTnai,N錼UNION ALL SELECTnan,N婻UNION ALL SELECTnang,N齉UNION ALL SELECTnao,N臑UNION ALL SELECTne,N呢UNION ALL SELECTnei,N焾--嫩焾UNION ALL SELECTnen,N嫩UNION ALL SELECTneng,N能--莻嗯鈪銰啱UNION ALL SELECTni,N嬺UNION ALL SELECTnian,N艌UNION ALL SELECTniang,N釀UNION ALL SELECTniao,N脲UNION ALL SELECTnie,N钀UNION ALL SELECTnin,N拰UNION ALL SELECTning,N濘UNION ALL SELECTniu,N靵UNION ALL SELECTnong,N齈UNION ALL SELECTnou,N譳UNION ALL SELECTnu,N搙UNION ALL SELECTnv,N衄UNION ALL SELECTnue,N瘧UNION ALL SELECTnuan,N燶--硸黁燶郍UNION ALL SELECTnuo,N桛UNION ALL SELECTo,N鞰--毮夞乯鞰UNION ALL SELECTou,N漚UNION ALL SELECTpa,N袙UNION ALL SELECTpai,N磗--鎃磗UNION ALL SELECTpan,N鑻UNION ALL SELECTpang,N胖UNION ALL SELECTpao,N礮UNION ALL SELECTpei,N轡UNION ALL SELECTpen,N喯UNION ALL SELECTpeng,N喸--浌巼闏乶喸UNION ALL SELECTpi,N鸊UNION ALL SELECTpian,N騙UNION ALL SELECTpiao,N慓UNION ALL SELECTpie,N嫳UNION ALL SELECTpin,N聘UNION ALL SELECTping,N蘋UNION ALL SELECTpo,N魄UNION ALL SELECTpou,N哛--兺哛UNION ALL SELECTpu,N曝UNION ALL SELECTqi,N蟿UNION ALL SELECTqia,N髂UNION ALL SELECTqian,N縴UNION ALL SELECTqiang,N瓩--羻兛瓩UNION ALL SELECTqiao,N躈UNION ALL SELECTqie,N籡UNION ALL SELECTqin,N藽UNION ALL SELECTqing,N櫦UNION ALL SELECTqiong,N瓗UNION ALL SELECTqiu,N糗UNION ALL SELECTqu,N覻UNION ALL SELECTquan,N勸UNION ALL SELECTque,N礭UNION ALL SELECTqun,N囕UNION ALL SELECTran,N橪UNION ALL SELECTrang,N讓UNION ALL SELECTrao,N繞UNION ALL SELECTre,N熱UNION ALL SELECTren,N餁UNION ALL SELECTreng,N陾UNION ALL SELECTri,N馹UNION ALL SELECTrong,N穃UNION ALL SELECTrou,N嶿UNION ALL SELECTru,N擩UNION ALL SELECTruan,N礝UNION ALL SELECTrui,N壡UNION ALL SELECTrun,N橍--橍挼UNION ALL SELECTruo,N鶸UNION ALL SELECTsa,N栍--櫒栍UNION ALL SELECTsai,N虄--簺虄UNION ALL SELECTsan,N閐UNION ALL SELECTsang,N喪UNION ALL SELECTsao,N髞UNION ALL SELECTse,N飋--裇聓UNION ALL SELECTsen,N篸UNION ALL SELECTseng,N縇--閪縇UNION ALL SELECTsha,N霎UNION ALL SELECTshai,N曬UNION ALL SELECTshan,N鱔UNION ALL SELECTshang,N緔UNION ALL SELECTshao,N潲UNION ALL SELECTshe,N欇UNION ALL SELECTshen,N瘮UNION ALL SELECTsheng,N賸UNION ALL SELECTshi,N瓧--鰘齛兙瓧UNION ALL SELECTshou,N鏉UNION ALL SELECTshu,N虪UNION ALL SELECTshua,N誜UNION ALL SELECTshuai,N卛UNION ALL SELECTshuan,N腨UNION ALL SELECTshuang,N灀UNION ALL SELECTshui,N睡UNION ALL SELECTshun,N鬊UNION ALL SELECTshuo,N鑠UNION ALL SELECTsi,N乺--瀃螦乺UNION ALL SELECTsong,N鎹UNION ALL SELECTsou,N瘶UNION ALL SELECTsu,N鷫UNION ALL SELECTsuan,N算UNION ALL SELECTsui,N鐩UNION ALL SELECTsun,N潠UNION ALL SELECTsuo,N蜶UNION ALL SELECTta,N襨--躢襨UNION ALL SELECTtai,N燤UNION ALL SELECTtan,N賧UNION ALL SELECTtang,N燙UNION ALL SELECTtao,N畓--討畓UNION ALL SELECTte,N蟘UNION ALL SELECTteng,N朰--霯唞朰UNION ALL SELECTti,N趯UNION ALL SELECTtian,N舚UNION ALL SELECTtiao,N糶UNION ALL SELECTtie,N餮UNION ALL SELECTting,N乭--濎乭UNION ALL SELECTtong,N憅UNION ALL SELECTtou,N透UNION ALL SELECTtu,N鵵UNION ALL SELECTtuan,N褖UNION ALL SELECTtui,N駾UNION ALL SELECTtun,N坉UNION ALL SELECTtuo,N籜UNION ALL SELECTwa,N韤UNION ALL SELECTwai,N顡UNION ALL SELECTwan,N贎UNION ALL SELECTwang,N朢UNION ALL SELECTwei,N躛UNION ALL SELECTwen,N璺UNION ALL SELECTweng,N齆UNION ALL SELECTwo,N齷UNION ALL SELECTwu,N鶩UNION ALL SELECTxi,N衋UNION ALL SELECTxia,N鏬UNION ALL SELECTxian,N鼸UNION ALL SELECTxiang,N鱌UNION ALL SELECTxiao,N斆UNION ALL SELECTxie,N躞UNION ALL SELECTxin,N釁UNION ALL SELECTxing,N臖UNION ALL SELECTxiong,N敻UNION ALL SELECTxiu,N齅UNION ALL SELECTxu,N蓿UNION ALL SELECTxuan,N贙UNION ALL SELECTxue,N瀥UNION ALL SELECTxun,N鑂UNION ALL SELECTya,N齾UNION ALL SELECTyan,N灩UNION ALL SELECTyang,N樣UNION ALL SELECTyao,N鑰UNION ALL SELECTye,N岃--鸈膶岃UNION ALL SELECTyi,N齸UNION ALL SELECTyin,N檼UNION ALL SELECTying,N譍UNION ALL SELECTyo,N喲UNION ALL SELECTyong,N醟UNION ALL SELECTyou,N鼬UNION ALL SELECTyu,N爩UNION ALL SELECTyuan,N願UNION ALL SELECTyue,N鸙UNION ALL SELECTyun,N韻UNION ALL SELECTza,N雥UNION ALL SELECTzai,N縡UNION ALL SELECTzan,N饡UNION ALL SELECTzang,N臟UNION ALL SELECTzao,N竈UNION ALL SELECTze,N稄UNION ALL SELECTzei,N鱡UNION ALL SELECTzen,N囎UNION ALL SELECTzeng,N贈UNION ALL SELECTzha,N醡UNION ALL SELECTzhai,N瘵UNION ALL SELECTzhan,N驏UNION ALL SELECTzhang,N瞕UNION ALL SELECTzhao,N羄UNION ALL SELECTzhe,N鷓UNION ALL SELECTzhen,N黮UNION ALL SELECTzheng,N證UNION ALL SELECTzhi,N豒UNION ALL SELECTzhong,N諥UNION ALL SELECTzhou,N驟UNION ALL SELECTzhu,N鑄UNION ALL SELECTzhua,N爪UNION ALL SELECTzhuai,N跩UNION ALL SELECTzhuan,N籑UNION ALL SELECTzhuang,N戅UNION ALL SELECTzhui,N鑆UNION ALL SELECTzhun,N稕UNION ALL SELECTzhuo,N籱UNION ALL SELECTzi,N漬--漬唨UNION ALL SELECTzong,N縱UNION ALL SELECTzou,N媰UNION ALL SELECTzu,N謯UNION ALL SELECTzuan,N攥UNION ALL SELECTzui,N欈UNION ALL SELECTzun,N銌UNION ALL SELECTzuo,N咗) t WHERE word 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
SELECT dbo.fn_GetPinyin(阿门) 执行完上面SQL ,执行下面sql
SELECT dbo.fn_GetPinyin(阿门)-- 得到a men
