| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mssql >> jie xi Microsoft Sql Server zhong de like yu ju
 

jie xi Microsoft Sql Server zhong de like yu ju

2008-12-13 08:23:53 编辑來源:互联网 评论
 
本文为【解析Microsoft Sql Server中的like语句】的拼音翻译版
  LIKE, que ding gei ding de zi fu chuan shi fou yu zhi ding de mo shi pi pei 。 mo shi ke yi bao han chang gui zi fu he tong pei fu zi fu 。 mo shi pi pei guo cheng zhong , chang gui zi fu bi xu yu zi fu chuan zhong zhi ding de zi fu wan quan pi pei 。 ran er , ke shi yong zi fu chuan de ren yi pian duan pi pei tong pei fu 。 yu shi yong = he != zi fu chuan bi jiao yun suan fu xiang bi , shi yong tong pei fu ke shi LIKE yun suan fu geng jia ling huo 。
  ru guo ren he shen shu dou bu shu yu zi fu chuan shu ju lei xing ,Microsoft® SQL Server™ hui jiang qi zhuan huan cheng zi fu chuan shu ju lei xing ( ru guo ke neng )。
  yu fa view plaincopy to clipboardprint?
  match_expression [ NOT ] LIKE pattern [ ESCAPE escape_character ]
  match_expression [ NOT ] LIKE pattern [ ESCAPE escape_character ] shen shu
  match_expression
  ren he zi fu chuan shu ju lei xing de you xiao SQL Server biao da shi 。
  pattern
  match_expression zhong de sou suo mo shi , ke yi bao han xia lie you xiao SQL Server tong pei fu 。
  tong pei fu miao shu shi li
  % bao han ling ge huo geng duo zi fu de ren yi zi fu chuan 。 WHERE title LIKE '%computer%' jiang cha zhao chu yu shu ming ren yi wei zhi de bao han dan ci computer de suo you shu ming 。
  _( xia hua xian ) ren he dan ge zi fu 。 WHERE au_fname LIKE '_ean' jiang cha zhao yi ean jie yi de suo you 4 ge zi mu de ming zi (Dean、Sean deng )。
  [ ] zhi ding fan wei ([a-f]) huo ji he ([abcdef]) zhong de ren he dan ge zi fu 。 WHERE au_lname LIKE '[C-P]arsen' jiang cha zhao yi arsen jie yi qie yi jie yu C yu P zhi jian de ren he dan ge zi fu kai shi de zuo zhe xing shi , li ru ,Carsen、Larsen、Karsen deng 。
  [^] bu shu yu zhi ding fan wei ([a-f]) huo ji he ([abcdef]) de ren he dan ge zi fu 。 WHERE au_lname LIKE 'de[^l]%' jiang cha zhao yi de kai shi qie qi hou de zi mu bu wei l de suo you zuo zhe de xing shi 。
  escape_character
  zi fu chuan shu ju lei xing fen lei zhong de suo you shu ju lei xing de ren he you xiao SQL Server biao da shi 。escape_character mei you mo ren zhi , qie bi xu jin bao han yi ge zi fu 。
  jie guo lei xing
  Boolean
  jie guo zhi
  ru guo match_expression pi pei zhi ding mo shi ,LIKE jiang fan hui TRUE。
  zhu shi
  dang shi yong LIKE jin xing zi fu chuan bi jiao shi , mo shi zi fu chuan zhong de suo you zi fu dou you yi yi , bao kuo qi shi huo yi sui kong ge 。 ru guo cha xun zhong de bi jiao yao fan hui bao han "abc "(abc hou you yi ge kong ge ) de suo you xing , ze jiang bu hui fan hui bao han "abc"(abc hou mei you kong ge ) de lie suo zai xing 。 dan shi ke yi hu lue mo shi suo yao pi pei de biao da shi zhong de yi sui kong ge 。 ru guo cha xun zhong de bi jiao yao fan hui bao han "abc"(abc hou mei you kong ge ) de suo you xing , ze jiang fan hui yi "abc" kai shi qie ju you ling ge huo duo ge yi sui kong ge de suo you xing 。
  ben tie lai zi ZDNetChina zhong wen she qu http://bbs.zdnet.com.cn , ben tie di zhi :http://bbs.zdnet.com.cn/viewthread.php?tid=94371
  you yu shu ju cun chu fang shi de yuan yin , shi yong bao han char he varchar shu ju mo shi de zi fu chuan bi jiao ke neng wu fa tong guo LIKE bi jiao 。 le jie mei zhong shu ju lei xing de cun chu fang shi yi ji dao zhi LIKE bi jiao shi bai de yuan yin shi fen chong yao 。 xia mian de shi li jiang ju bu char bian liang chuan di gei cun chu guo cheng , ran hou shi yong mo shi pi pei cha zhao mou ge zuo zhe de suo you zhu zuo 。 zai ci guo cheng zhong , yong yi ge xing shi zuo wei bian liang chuan di 。 view plaincopy to clipboardprint?
  CREATE PROCEDURE find_books @AU_LNAME char(20)
  AS
  SELECT @AU_LNAME = RTRIM(@AU_LNAME) + '%'
  SELECT t.title_id, t.title
  FROM authors a, titleauthor ta, titles t
  WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id
  AND a.au_lname LIKE @AU_LNAME
  CREATE PROCEDURE find_books @AU_LNAME char(20)
  AS
  SELECT @AU_LNAME = RTRIM(@AU_LNAME) + '%'
  SELECT t.title_id, t.title
  FROM authors a, titleauthor ta, titles t
  WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id
  AND a.au_lname LIKE @AU_LNAME dang ming zi zhong bao han de zi fu shu xiao yu 20 shi ,char bian liang (@AU_LNAME) jiang bao han yi sui kong ge , zhe dao zhi find_books guo cheng zhong mei you xing fan hui 。 you yu au_lname lie wei varchar lei xing , suo yi mei you yi sui kong ge 。 yin wei yi sui kong ge shi you yi yi de , suo yi ci guo cheng shi bai 。
  dan xia mian de shi li shi cheng gong de , yin wei yi sui kong ge mei you bei tian jia dao varchar bian liang zhong : view plaincopy to clipboardprint?
  USE pubs
  GO
  CREATE PROCEDURE find_books2 @au_lname varchar(20)
  AS
  SELECT t.title_id, t.title
  FROM authors a, titleauthor ta, titles t
  WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id
  AND a.au_lname LIKE @au_lname + '%'
  EXEC find_books2 'ring'
  USE pubs
  GO
  CREATE PROCEDURE find_books2 @au_lname varchar(20)
  AS
  SELECT t.title_id, t.title
  FROM authors a, titleauthor ta, titles t
  WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id
  AND a.au_lname LIKE @au_lname + '%'
  EXEC find_books2 'ring' xia mian shi jie guo ji :
  title_id title
  -------- -----------------
  MC3021 The Gourmet Microwave
  PS2091 Is Anger the Enemy?
  PS2091 Is Anger the Enemy?
  PS2106 Life Without Fear
  (4 row(s) affected)
  you yu shu ju cun chu fang shi de yuan yin , shi yong bao han char he varchar shu ju mo shi de zi fu chuan bi jiao ke neng wu fa tong guo LIKE bi jiao 。 le jie mei zhong shu ju lei xing de cun chu fang shi yi ji dao zhi LIKE bi jiao shi bai de yuan yin shi fen chong yao 。 xia mian de shi li jiang ju bu char bian liang chuan di gei cun chu guo cheng , ran hou shi yong mo shi pi pei cha zhao mou ge zuo zhe de suo you zhu zuo 。 zai ci guo cheng zhong , yong yi ge xing shi zuo wei bian liang chuan di 。 view plaincopy to clipboardprint?
  CREATE PROCEDURE find_books @AU_LNAME char(20)
  AS
  SELECT @AU_LNAME = RTRIM(@AU_LNAME) + '%'
  SELECT t.title_id, t.title
  FROM authors a, titleauthor ta, titles t
  WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id
  AND a.au_lname LIKE @AU_LNAME
  CREATE PROCEDURE find_books @AU_LNAME char(20)
  AS
  SELECT @AU_LNAME = RTRIM(@AU_LNAME) + '%'
  SELECT t.title_id, t.title
  FROM authors a, titleauthor ta, titles t
  WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id
  AND a.au_lname LIKE @AU_LNAME dang ming zi zhong bao han de zi fu shu xiao yu 20 shi ,char bian liang (@AU_LNAME) jiang bao han yi sui kong ge , zhe dao zhi find_books guo cheng zhong mei you xing fan hui 。 you yu au_lname lie wei varchar lei xing , suo yi mei you yi sui kong ge 。 yin wei yi sui kong ge shi you yi yi de , suo yi ci guo cheng shi bai 。
  dan xia mian de shi li shi cheng gong de , yin wei yi sui kong ge mei you bei tian jia dao varchar bian liang zhong : view plaincopy to clipboardprint?
  USE pubs
  GO
  CREATE PROCEDURE find_books2 @au_lname varchar(20)
  AS
  SELECT t.title_id, t.title
  FROM authors a, titleauthor ta, titles t
  WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id
  AND a.au_lname LIKE @au_lname + '%'
  EXEC find_books2 'ring'
  USE pubs
  GO
  CREATE PROCEDURE find_books2 @au_lname varchar(20)
  AS
  SELECT t.title_id, t.title
  FROM authors a, titleauthor ta, titles t
  WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id
  AND a.au_lname LIKE @au_lname + '%'
  EXEC find_books2 'ring' xia mian shi jie guo ji :
  title_id title
  -------- -----------------
  MC3021 The Gourmet Microwave
  PS2091 Is Anger the Enemy?
  PS2091 Is Anger the Enemy?
  PS2106 Life Without Fear
  (4 row(s) affected)【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
LIKE, que ding gei ding de zi fu chuan shi fou yu zhi ding de mo shi pi pei 。 mo shi ke yi bao han chang gui zi fu he tong pei fu zi fu 。 mo shi pi pei guo cheng zhong , chang gui zi fu bi xu yu zi fu chuan zhong zhi ding de zi fu wan quan pi pei 。 ran er , ke shi yong zi fu chuan de ren yi pian duan pi pei tong pei fu 。 yu shi yong = he != zi fu chuan bi jiao yun suan fu xiang bi , shi yong tong pei fu ke shi LIKE yun suan fu geng jia ling huo 。 ru guo ren he shen shu dou bu shu yu zi fu chuan shu ju lei xing ,Microsoft® SQL Server™ hui jiang qi zhuan huan cheng zi fu chuan shu ju lei xing ( ru guo ke neng )。 yu fa view plaincopy to clipboardprint? match_expression [ NOT ] LIKE pattern [ ESCAPE escape_character ] match_expression [ NOT ] LIKE pattern [ ESCAPE escape_character ] shen shu match_expression ren he zi fu chuan shu ju lei xing de you xiao SQL Server biao da shi 。 pattern match_expression zhong de sou suo mo shi , ke yi bao han xia lie you xiao SQL Server tong pei fu 。 tong pei fu miao shu shi li % bao han ling ge huo geng duo zi fu de ren yi zi fu chuan 。 WHERE title LIKE '%computer%' jiang cha zhao chu yu shu ming ren yi wei zhi de bao han dan ci computer de suo you shu ming 。 _( xia hua xian ) ren he dan ge zi fu 。 WHERE au_fname LIKE '_ean' jiang cha zhao yi ean jie yi de suo you 4 ge zi mu de ming zi (Dean、Sean deng )。 [ ] zhi ding fan wei ([a-f]) huo ji he ([abcdef]) zhong de ren he dan ge zi fu 。 WHERE au_lname LIKE '[C-P]arsen' jiang cha zhao yi arsen jie yi qie yi jie yu C yu P zhi jian de ren he dan ge zi fu kai shi de zuo zhe xing shi , li ru ,Carsen、Larsen、Karsen deng 。 [^] bu shu yu zhi ding fan wei ([a-f]) huo ji he ([abcdef]) de ren he dan ge zi fu 。 WHERE au_lname LIKE 'de[^l]%' jiang cha zhao yi de kai shi qie qi hou de zi mu bu wei l de suo you zuo zhe de xing shi 。 escape_character zi fu chuan shu ju lei xing fen lei zhong de suo you shu ju lei xing de ren he you xiao SQL Server biao da shi 。escape_character mei you mo ren zhi , qie bi xu jin bao han yi ge zi fu 。 jie guo lei xing Boolean jie guo zhi ru guo match_expression pi pei zhi ding mo shi ,LIKE jiang fan hui TRUE。 zhu shi dang shi yong LIKE jin xing zi fu chuan bi jiao shi , mo shi zi fu chuan zhong de suo you zi fu dou you yi yi , bao kuo qi shi huo yi sui kong ge 。 ru guo cha xun zhong de bi jiao yao fan hui bao han "abc "(abc hou you yi ge kong ge ) de suo you xing , ze jiang bu hui fan hui bao han "abc"(abc hou mei you kong ge ) de lie suo zai xing 。 dan shi ke yi hu lue mo shi suo yao pi pei de biao da shi zhong de yi sui kong ge 。 ru guo cha xun zhong de bi jiao yao fan hui bao han "abc"(abc hou mei you kong ge ) de suo you xing , ze jiang fan hui yi "abc" kai shi qie ju you ling ge huo duo ge yi sui kong ge de suo you xing 。 ben tie lai zi ZDNetChina zhong wen she qu [url=http://bbs.zdnet.com.cn]http://bbs.zdnet.com.cn[/url] , ben tie di zhi :[url=http://bbs.zdnet.com.cn/viewthread.php?tid=94371]http://bbs.zdnet.com.cn/viewthread.php?tid=94371[/url] you yu shu ju cun chu fang shi de yuan yin , shi yong bao han char he varchar shu ju mo shi de zi fu chuan bi jiao ke neng wu fa tong guo LIKE bi jiao 。 le jie mei zhong shu ju lei xing de cun chu fang shi yi ji dao zhi LIKE bi jiao shi bai de yuan yin shi fen chong yao 。 xia mian de shi li jiang ju bu char bian liang chuan di gei cun chu guo cheng , ran hou shi yong mo shi pi pei cha zhao mou ge zuo zhe de suo you zhu zuo 。 zai ci guo cheng zhong , yong yi ge xing shi zuo wei bian liang chuan di 。 view plaincopy to clipboardprint? CREATE PROCEDURE find_books @AU_LNAME char(20) AS SELECT @AU_LNAME = RTRIM(@AU_LNAME) + '%' SELECT t.title_id, t.title FROM authors a, titleauthor ta, titles t WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND a.au_lname LIKE @AU_LNAME CREATE PROCEDURE find_books @AU_LNAME char(20) AS SELECT @AU_LNAME = RTRIM(@AU_LNAME) + '%' SELECT t.title_id, t.title FROM authors a, titleauthor ta, titles t WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND a.au_lname LIKE @AU_LNAME dang ming zi zhong bao han de zi fu shu xiao yu 20 shi ,char bian liang (@AU_LNAME) jiang bao han yi sui kong ge , zhe dao zhi find_books guo cheng zhong mei you xing fan hui 。 you yu au_lname lie wei varchar lei xing , suo yi mei you yi sui kong ge 。 yin wei yi sui kong ge shi you yi yi de , suo yi ci guo cheng shi bai 。 dan xia mian de shi li shi cheng gong de , yin wei yi sui kong ge mei you bei tian jia dao varchar bian liang zhong : view plaincopy to clipboardprint? USE pubs GO CREATE PROCEDURE find_books2 @au_lname varchar(20) AS SELECT t.title_id, t.title FROM authors a, titleauthor ta, titles t WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND a.au_lname LIKE @au_lname + '%' EXEC find_books2 'ring' USE pubs GO CREATE PROCEDURE find_books2 @au_lname varchar(20) AS SELECT t.title_id, t.title FROM authors a, titleauthor ta, titles t WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND a.au_lname LIKE @au_lname + '%' EXEC find_books2 'ring' xia mian shi jie guo ji : title_id title -------- ----------------- MC3021 The Gourmet Microwave PS2091 Is Anger the Enemy? PS2091 Is Anger the Enemy? PS2106 Life Without Fear (4 row(s) affected) you yu shu ju cun chu fang shi de yuan yin , shi yong bao han char he varchar shu ju mo shi de zi fu chuan bi jiao ke neng wu fa tong guo LIKE bi jiao 。 le jie mei zhong shu ju lei xing de cun chu fang shi yi ji dao zhi LIKE bi jiao shi bai de yuan yin shi fen chong yao 。 xia mian de shi li jiang ju bu char bian liang chuan di gei cun chu guo cheng , ran hou shi yong mo shi pi pei cha zhao mou ge zuo zhe de suo you zhu zuo 。 zai ci guo cheng zhong , yong yi ge xing shi zuo wei bian liang chuan di 。 view plaincopy to clipboardprint? CREATE PROCEDURE find_books @AU_LNAME char(20) AS SELECT @AU_LNAME = RTRIM(@AU_LNAME) + '%' SELECT t.title_id, t.title FROM authors a, titleauthor ta, titles t WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND a.au_lname LIKE @AU_LNAME CREATE PROCEDURE find_books @AU_LNAME char(20) AS SELECT @AU_LNAME = RTRIM(@AU_LNAME) + '%' SELECT t.title_id, t.title FROM authors a, titleauthor ta, titles t WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND a.au_lname LIKE @AU_LNAME dang ming zi zhong bao han de zi fu shu xiao yu 20 shi ,char bian liang (@AU_LNAME) jiang bao han yi sui kong ge , zhe dao zhi find_books guo cheng zhong mei you xing fan hui 。 you yu au_lname lie wei varchar lei xing , suo yi mei you yi sui kong ge 。 yin wei yi sui kong ge shi you yi yi de , suo yi ci guo cheng shi bai 。 dan xia mian de shi li shi cheng gong de , yin wei yi sui kong ge mei you bei tian jia dao varchar bian liang zhong : view plaincopy to clipboardprint? USE pubs GO CREATE PROCEDURE find_books2 @au_lname varchar(20) AS SELECT t.title_id, t.title FROM authors a, titleauthor ta, titles t WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND a.au_lname LIKE @au_lname + '%' EXEC find_books2 'ring' USE pubs GO CREATE PROCEDURE find_books2 @au_lname varchar(20) AS SELECT t.title_id, t.title FROM authors a, titleauthor ta, titles t WHERE a.au_id = ta.au_id AND ta.title_id = t.title_id AND a.au_lname LIKE @au_lname + '%' EXEC find_books2 'ring' xia mian shi jie guo ji : title_id title -------- ----------------- MC3021 The Gourmet Microwave PS2091 Is Anger the Enemy? PS2091 Is Anger the Enemy? PS2106 Life Without Fear (4 row(s) affected)
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
我们约会吧
漂亮白皙的模特
好纯好美的女生
靓丽的网络美女
痞子的甘南日记
疑是银河落九天
雪域坝上四——纯美色
冬日恋歌——西城杨柳弄轻柔
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有