读书人
栏目▼

从获取拼音函数得到的一点体会不对的

发布时间： 2012-01-30 21:15:58 作者： rapoo

从获取拼音函数得到的一点体会，不对的地方欢迎指正

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 --内容过长，下续


[解决办法]
sf
[解决办法]
学习.
[解决办法]
学习
[解决办法]
SQL code
select dbo.fn_GetPinyin(N'杨')--结果zuo
[解决办法]
手有境 繁用 我得繁
SELECT PATINDEX(N'%[吖-]%' COLLATE Chinese_PRC_CS_AS_KS_WS,N'中文字符')  
似乎有
[解决办法]
学习
[解决办法]
支持
[解决办法]
学习,强列学习TONY哥
[解决办法]
好东东，支持！
[解决办法]
学习！
[解决办法]
此贴要火~~~~
[解决办法]
.
[解决办法]
看不懂
[解决办法]
学习。

[解决办法]
厉害~

[解决办法]
^_^
[解决办法]
jf
[解决办法]
budong!
[解决办法]
路过
[解决办法]
学习
[解决办法]
是繁体有简体的吗
[解决办法]
神贴~
[解决办法]
学习
[解决办法]
不懂
[解决办法]
支持
[解决办法]
？
看不懂
[解决办法]
学习
[解决办法]
这个很强大！
[解决办法]
太厉害了
佩服佩服
呵呵

[解决办法]
http://zhao4zhong1.download.csdn.net/
到这里下载GBK汉字拼音对照表
[解决办法]
N XX
[解决办法]
.
[解决办法]
这个真要学习
------解决方案-------------------- 
 
火了
[解决办法]
看看
[解决办法]
学习中~~~
[解决办法]
henhao duiwo meiyou yong
[解决办法]
厉害,学习了
[解决办法]
好东西~学习ing~
[解决办法]
佩服太厉害了
[解决办法]
学习 收藏了
[解决办法]
不懂哦
帮顶一下
[解决办法]
学习~
[解决办法]
收藏

[解决办法]
d
[解决办法]
学习，收藏。
[解决办法]
说实话,我一直没觉得这样的东西有什么用?
什么样的系统会用到这些功能?

不如建立一个对应表.
[解决办法]
例如:

捉这个字,其首字母到底是 z 还是 zh

爱这个字,其首字母到底是 a 还是 ai

[解决办法]
好象我理解错了楼主的意思.不好意思.
[解决办法]
强人~~！！学习~~
[解决办法]
好长！
[解决办法]
请问，多音字的咋整？
[解决办法]
学习下。。
[解决办法]
那个好长的说!
[解决办法]
这里面能把所有的字查询出来吗？
[解决办法]
。
[解决办法]
什么会应用到这个？
[解决办法]
其实，汉字编码的时候有没有对应拼音？这种查字典式的做法太繁琐了。
输入法是如何实现的？难道也是查字典？
[解决办法]
如果使用C#，微软是直接有提供相关的拼音工具库使用的。。。。
[解决办法]
不懂
读书人网 >SQL Server

热点推荐

触屏版 | 电脑版

读书人网 m.reader8.net