SQL code/*----------------------------------- Author : htl258(Tony)-- Date : 2009-09-18 19:03:53-- Version: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 2)---------------------------------*/--1.创建表[t_GetPinyin],建在函数外,目的为了提高查询效率IF OBJECT_ID('[t_GetPinyin]') IS NOT NULL DROP TABLE [t_GetPinyin] GOCREATE TABLE [t_GetPinyin]([py] NVARCHAR(20),[word] NVARCHAR(10) COLLATE Chinese_PRC_CS_AS_KS_WS)INSERT [t_GetPinyin] SELECT 'a' ,N'厑' UNION ALLSELECT 'ai',N'靉' UNION ALL SELECT 'an',N'黯' UNION ALL SELECT 'ang',N'醠' UNION ALL SELECT 'ao',N'驁' UNION ALL SELECT 'ba',N'欛' UNION ALL SELECT 'bai',N'瓸' UNION ALL --韛兡瓸SELECT 'ban',N'瓣' UNION ALL SELECT 'bang',N'鎊' UNION ALL SELECT 'bao',N'鑤' UNION ALL SELECT 'bei',N'鐾' UNION ALL SELECT 'ben',N'輽' UNION ALL SELECT 'beng',N'鏰' UNION ALL SELECT 'bi',N'鼊' UNION ALL SELECT 'bian',N'變' UNION ALL SELECT 'biao',N'鰾' UNION ALL SELECT 'bie',N'彆' UNION ALL SELECT 'bin',N'鬢' UNION ALL SELECT 'bing',N'靐' UNION ALL SELECT 'bo',N'蔔' UNION ALL SELECT 'bu',N'簿' UNION ALL SELECT 'ca',N'囃' UNION ALL SELECT 'cai',N'乲' UNION ALL --縩乲 SELECT 'can',N'爘' UNION ALL SELECT 'cang',N'賶' UNION ALL SELECT 'cao',N'鼜' UNION ALL SELECT 'ce',N'簎' UNION ALL SELECT 'cen',N'笒' UNION ALL SELECT 'ceng',N'乽' UNION ALL --硛硳岾猠乽SELECT 'cha',N'詫' UNION ALL SELECT 'chai',N'囆' UNION ALL SELECT 'chan',N'顫' UNION ALL SELECT 'chang',N'韔' UNION ALL SELECT 'chao',N'觘' UNION ALL SELECT 'che',N'爡' UNION ALL SELECT 'chen',N'讖' UNION ALL SELECT 'cheng',N'秤' UNION ALL SELECT 'chi',N'鷘' UNION ALL SELECT 'chong',N'銃' UNION ALL SELECT 'chou',N'殠' UNION ALL SELECT 'chu',N'矗' UNION ALL SELECT 'chuai',N'踹' UNION ALL SELECT 'chuan',N'鶨' UNION ALL SELECT 'chuang',N'愴' UNION ALL SELECT 'chui',N'顀' UNION ALL SELECT 'chun',N'蠢' UNION ALL SELECT 'chuo',N'縒' UNION ALL SELECT 'ci',N'嗭' UNION ALL --賜嗭SELECT 'cong',N'謥' UNION ALL SELECT 'cou',N'輳' UNION ALL SELECT 'cu',N'顣' UNION ALL SELECT 'cuan',N'爨' UNION ALL SELECT 'cui',N'臎' UNION ALL SELECT 'cun',N'籿' UNION ALL SELECT 'cuo',N'錯' UNION ALL SELECT 'da',N'橽' UNION ALL SELECT 'dai',N'靆' UNION ALL SELECT 'dan',N'饏' UNION ALL SELECT 'dang',N'闣' UNION ALL SELECT 'dao',N'纛' UNION ALL SELECT 'de',N'的' UNION ALL SELECT 'den',N'扽' UNION ALL SELECT 'deng',N'鐙' UNION ALL SELECT 'di',N'螮' UNION ALL SELECT 'dia',N'嗲' UNION ALL SELECT 'dian',N'驔' UNION ALL SELECT 'diao',N'鑃' UNION ALL SELECT 'die',N'嚸' UNION ALL --眰嚸SELECT 'ding',N'顁' UNION ALL SELECT 'diu',N'銩' UNION ALL SELECT 'dong',N'霘' UNION ALL SELECT 'dou',N'鬭' UNION ALL SELECT 'du',N'蠹' UNION ALL SELECT 'duan',N'叾' UNION ALL --籪叾SELECT 'dui',N'譵' UNION ALL SELECT 'dun',N'踲' UNION ALL SELECT 'duo',N'鵽' UNION ALL SELECT 'e',N'鱷' UNION ALL SELECT 'en',N'摁' UNION ALL SELECT 'eng',N'鞥' UNION ALL SELECT 'er',N'樲' UNION ALL SELECT 'fa',N'髮' UNION ALL SELECT 'fan',N'瀪' UNION ALL SELECT 'fang',N'放' UNION ALL SELECT 'fei',N'靅' UNION ALL SELECT 'fen',N'鱝' UNION ALL SELECT 'feng',N'覅' UNION ALL SELECT 'fo',N'梻' UNION ALL SELECT 'fou',N'鴀' UNION ALL SELECT 'fu',N'猤' UNION ALL --鰒猤SELECT 'ga',N'魀' UNION ALL SELECT 'gai',N'瓂' UNION ALL SELECT 'gan',N'灨' UNION ALL SELECT 'gang',N'戇' UNION ALL SELECT 'gao',N'鋯' UNION ALL SELECT 'ge',N'獦' UNION ALL SELECT 'gei',N'給' UNION ALL SELECT 'gen',N'搄' UNION ALL SELECT 'geng',N'堩' UNION ALL --亙堩啹喼嗰SELECT 'gong',N'兣' UNION ALL --熕贑兝兣SELECT 'gou',N'購' UNION ALL SELECT 'gu',N'顧' UNION ALL SELECT 'gua',N'詿' UNION ALL SELECT 'guai',N'恠' UNION ALL SELECT 'guan',N'鱹' UNION ALL SELECT 'guang',N'撗' UNION ALL SELECT 'gui',N'鱥' UNION ALL SELECT 'gun',N'謴' UNION ALL SELECT 'guo',N'腂' UNION ALL SELECT 'ha',N'哈' UNION ALL SELECT 'hai',N'饚' UNION ALL SELECT 'han',N'鶾' UNION ALL SELECT 'hang',N'沆' UNION ALL SELECT 'hao',N'兞' UNION ALL SELECT 'he',N'靏' UNION ALL SELECT 'hei',N'嬒' UNION ALL SELECT 'hen',N'恨' UNION ALL SELECT 'heng',N'堼' UNION ALL --堼囍SELECT 'hong',N'鬨' UNION ALL SELECT 'hou',N'鱟' UNION ALL SELECT 'hu',N'鸌' UNION ALL SELECT 'hua',N'蘳' UNION ALL SELECT 'huai',N'蘾' UNION ALL SELECT 'huan',N'鰀' UNION ALL SELECT 'huang',N'鎤' UNION ALL SELECT 'hui',N'顪' UNION ALL SELECT 'hun',N'諢' UNION ALL SELECT 'huo',N'夻' UNION ALL SELECT 'ji',N'驥' UNION ALL SELECT 'jia',N'嗧' UNION ALL SELECT 'jian',N'鑳' UNION ALL SELECT 'jiang',N'謽' UNION ALL SELECT 'jiao',N'釂' UNION ALL SELECT 'jie',N'繲' UNION ALL SELECT 'jin',N'齽' UNION ALL SELECT 'jing',N'竸' UNION ALL SELECT 'jiong',N'蘔' UNION ALL SELECT 'jiu',N'欍' UNION ALL SELECT 'ju',N'爠' UNION ALL SELECT 'juan',N'羂' UNION ALL SELECT 'jue',N'钁' UNION ALL SELECT 'jun',N'攈' UNION ALL SELECT 'ka',N'鉲' UNION ALL SELECT 'kai',N'乫' UNION ALL --鎎乫SELECT 'kan',N'矙' UNION ALL SELECT 'kang',N'閌' UNION ALL SELECT 'kao',N'鯌' UNION ALL SELECT 'ke',N'騍' UNION ALL SELECT 'ken',N'褃' UNION ALL SELECT 'keng',N'鏗' UNION ALL --巪乬唟厼怾SELECT 'kong',N'廤' UNION ALL SELECT 'kou',N'鷇' UNION ALL SELECT 'ku',N'嚳' UNION ALL SELECT 'kua',N'骻' UNION ALL SELECT 'kuai',N'鱠' UNION ALL SELECT 'kuan',N'窾' UNION ALL SELECT 'kuang',N'鑛' UNION ALL SELECT 'kui',N'鑎' UNION ALL SELECT 'kun',N'睏' UNION ALL SELECT 'kuo',N'穒' UNION ALL SELECT 'la',N'鞡' UNION ALL SELECT 'lai',N'籟' UNION ALL SELECT 'lan',N'糷' UNION ALL SELECT 'lang',N'唥' UNION ALL SELECT 'lao',N'軂' UNION ALL SELECT 'le',N'餎' UNION ALL SELECT 'lei',N'脷' UNION ALL --嘞脷SELECT 'leng',N'睖' UNION ALL SELECT 'li',N'瓈' UNION ALL SELECT 'lia',N'倆' UNION ALL SELECT 'lian',N'纞' UNION ALL SELECT 'liang',N'鍄' UNION ALL SELECT 'liao',N'瞭' UNION ALL SELECT 'lie',N'鱲' UNION ALL SELECT 'lin',N'轥' UNION ALL --轥拎SELECT 'ling',N'炩' UNION ALL SELECT 'liu',N'咯' UNION ALL --瓼甅囖咯SELECT 'long',N'贚' UNION ALL SELECT 'lou',N'鏤' UNION ALL SELECT 'lu',N'氇' UNION ALL SELECT 'lv',N'鑢' UNION ALL SELECT 'luan',N'亂' UNION ALL SELECT 'lue',N'擽' UNION ALL SELECT 'lun',N'論' UNION ALL SELECT 'luo',N'鱳' UNION ALL SELECT 'ma',N'嘛' UNION ALL SELECT 'mai',N'霢' UNION ALL SELECT 'man',N'蘰' UNION ALL SELECT 'mang',N'蠎' UNION ALL SELECT 'mao',N'唜' UNION ALL SELECT 'me',N'癦' UNION ALL --癦呅SELECT 'mei',N'嚜' UNION ALL SELECT 'men',N'們' UNION ALL SELECT 'meng',N'霥' UNION ALL --霿踎SELECT 'mi',N'羃' UNION ALL SELECT 'mian',N'麵' UNION ALL SELECT 'miao',N'廟' UNION ALL SELECT 'mie',N'鱴' UNION ALL --鱴瓱SELECT 'min',N'鰵' UNION ALL SELECT 'ming',N'詺' UNION ALL SELECT 'miu',N'謬' UNION ALL SELECT 'mo',N'耱' UNION ALL --耱乮SELECT 'mou',N'麰' UNION ALL --麰蟱SELECT 'mu',N'旀' UNION ALL SELECT 'na',N'魶' UNION ALL SELECT 'nai',N'錼' UNION ALL SELECT 'nan',N'婻' UNION ALL SELECT 'nang',N'齉' UNION ALL SELECT 'nao',N'臑' UNION ALL SELECT 'ne',N'呢' UNION ALL SELECT 'nei',N'焾' UNION ALL --嫩焾SELECT 'nen',N'嫩' UNION ALL SELECT 'neng',N'能' UNION ALL --莻嗯鈪銰啱SELECT 'ni',N'嬺' UNION ALL SELECT 'nian',N'艌' UNION ALL SELECT 'niang',N'釀' UNION ALL SELECT 'niao',N'脲' UNION ALL SELECT 'nie',N'钀' UNION ALL SELECT 'nin',N'拰' UNION ALL SELECT 'ning',N'濘' UNION ALL SELECT 'niu',N'靵' UNION ALL SELECT 'nong',N'齈' UNION ALL SELECT 'nou',N'譳' UNION ALL SELECT 'nu',N'搙' UNION ALL SELECT 'nv',N'衄' UNION ALL SELECT 'nue',N'瘧' UNION ALL SELECT 'nuan',N'燶' UNION ALL --硸黁燶郍SELECT 'nuo',N'桛' UNION ALL SELECT 'o',N'鞰' UNION ALL --毮夞乯鞰SELECT 'ou',N'漚' UNION ALL SELECT 'pa',N'袙' UNION ALL SELECT 'pai',N'磗' UNION ALL --鎃磗SELECT 'pan',N'鑻' UNION ALL SELECT 'pang',N'胖' UNION ALL SELECT 'pao',N'礮' UNION ALL SELECT 'pei',N'轡' UNION ALL SELECT 'pen',N'喯' UNION ALL SELECT 'peng',N'喸' UNION ALL --浌巼闏乶喸SELECT 'pi',N'鸊' UNION ALL SELECT 'pian',N'騙' UNION ALL SELECT 'piao',N'慓' UNION ALL SELECT 'pie',N'嫳' UNION ALL SELECT 'pin',N'聘' UNION ALL SELECT 'ping',N'蘋' UNION ALL SELECT 'po',N'魄' UNION ALL SELECT 'pou',N'哛' UNION ALL --兺哛SELECT 'pu',N'曝' UNION ALL SELECT 'qi',N'蟿' UNION ALL SELECT 'qia',N'髂' UNION ALL SELECT 'qian',N'縴' UNION ALL SELECT 'qiang',N'瓩' UNION ALL --羻兛瓩SELECT 'qiao',N'躈' UNION ALL SELECT 'qie',N'籡' UNION ALL SELECT 'qin',N'藽' UNION ALL SELECT 'qing',N'櫦' UNION ALL SELECT 'qiong',N'瓗' UNION ALL SELECT 'qiu',N'糗' UNION ALL SELECT 'qu',N'覻' UNION ALL SELECT 'quan',N'勸' UNION ALL SELECT 'que',N'礭' UNION ALL SELECT 'qun',N'囕' UNION ALL SELECT 'ran',N'橪' UNION ALL SELECT 'rang',N'讓' UNION ALL SELECT 'rao',N'繞' UNION ALL SELECT 're',N'熱' UNION ALL --内容过长，下续