±¾Õ¾ÄÚÈÝËÑË÷£º
   ÄúµÄλÖãºËزÄÖйú>>½Ì³Ì >>Êý¾Ý¿â >>MS SQL >>һЩSelect¼ìË÷¸ß¼¶Ó÷¨£¨ÊÊÓÃÓÚmssql£© Ìá½»´íÎ󱨸æ
һЩSelect¼ìË÷¸ß¼¶Ó÷¨£¨ÊÊÓÃÓÚmssql£©
[ À´Ô´£ºËزÄÖйú | ×÷Õߣº| ʱ¼ä£º2006-01-12 14:15:22 | ä¯ÀÀ£ºÈË´Î ]

 
  ¡¡¡¡SQLÎå¸ö¼¯ºÏº¯Êý£ºSUM,AVG,COUNT,MAX,MIN

¡¡¡¡Í¨Åä·ûµÄһЩÓ÷¨£º(¹Ø¼ü×Ö£ºlike % [] -)
¡¡¡¡select * from tablename where column1 like '[A-M]%'
¡¡¡¡ÕâÑù¿ÉÒÔÑ¡Ôñ³öcolumn×Ö¶ÎÖÐÊ××ÖĸÔÚA-MÖ®¼äµÄ¼Ç¼
¡¡¡¡select * from tablename where column1 like '[ABC]%'
¡¡¡¡ÕâÑù¿ÉÒÔÑ¡Ôñ³öcolumn×Ö¶ÎÖÐÊ××ÖĸÊÇA»òÕßB»òÕßCµÄ¼Ç¼
¡¡¡¡select * from tablename where column1 like '[A-CG]%'
¡¡¡¡ÕâÑù¿ÉÒÔÑ¡Ôñ³öcolumn×Ö¶ÎÖÐÊ××ÖĸÔÚA-CÖ®¼äµÄ»òÕßÊÇGµÄ¼Ç¼
¡¡¡¡select * from tablename where column1 like '[^C]%'
¡¡¡¡ÕâÑù¿ÉÒÔÑ¡Ôñ³öcolumn×Ö¶ÎÖÐÊ××Öĸ²»ÊÇCµÄ¼Ç¼

¡¡¡¡ÍÑ×Ö·û£¨¹Ø¼ü×Ö£ºlike _£©
¡¡¡¡Í¨¹ýʹÓÃÏ»¬Ïß×Ö·û£¨_£©£¬¿ÉÒÔÆ¥ÅäÈÎÒâµ¥¸ö×Ö·û
¡¡¡¡select * from tablename where column1 like 'M_crosoft'

¡¡¡¡Æ¥ÅäÌØÊâ×Ö·û£º£¨[ ] _ - %£©
¡¡¡¡°ÑËûÃǶ¼·Åµ½[]ÖоÍÐÐÁË£¬±ÈÈ磺
¡¡¡¡select * from tablename where column1 like '%[%]%'

¡¡¡¡Æ¥Åä·¢Òô£¨¹Ø¼ü×Ö£ºSOUNDEX DIFFERENCE£©
¡¡¡¡Èç¹û²»ÖªµÀÒ»¸öÃû×ÖÈ·Çеķ¢Òô£¬µ«ÊÇÓÖ¶àÉÙÖªµÀÒ»µã£¬¿ÉÒÔ¿¼ÂÇʹÓÃSOUNDEX DIFFERENCEº¯Êý¡£
¡¡¡¡select * from tablename where DIFFERENCE(column1,'Laofei'>3)
¡¡¡¡DIFFERENCE·µ»Ø0-4Ö®¼äµÄÊý×Ö£¬4ÊǷdz£½Ó½ü£¬0ÊDzîÒì·Ç³£´ó
¡¡¡¡ÒªÉîÈëÁ˽âDIFFERENCEº¯ÊýµÄ¹¤×÷Ô­Àí£¬Ê¹ÓÃSOUNDEXº¯Êý·µ»ØDIFFERENCEº¯ÊýËùʹÓõÄÒô±êÂë
¡¡¡¡select column1 as column,SOUNDEX(column1) 'sound like'

¡¡¡¡×¢Ò⣺
¡¡¡¡DIFFERENCEº¯Êý±È½ÏÁ½¸ö×Ö·û´®µÄµÚÒ»¸ö×ÖĸºÍËùÓеĸ¨Òô×Öĸ£¬¸Ãº¯ÊýºöÂÔÈκÎÔªÒô×Öĸ£¨°üÀ¨Y£©,³ý·ÇÔªÒô×ÖĸÊǸÃ×Ö·û´®µÄµÚÒ»¸ö×Öĸ¡£
¡¡¡¡Ê¹ÓÃÕâÁ½¸öº¯ÊýÔÚwhereÖÐÖ´ÐÐЧ¹û²¢²»ºÃ£¬ËùÒÔ¾¡Á¿ÉÙʹÓá£

 
 
       
   ÄúµÄλÖãºËزÄÖйú>>½Ì³Ì >>Êý¾Ý¿â >>MS SQL >>һЩSelect¼ìË÷¸ß¼¶Ó÷¨£¨ÊÊÓÃÓÚmssql£©
 µã´ËÔÚ°Ù¶ÈËÑË÷¹Ø¼ü×Ö"һЩSelect¼ìË÷¸ß¼¶Ó÷¨£¨ÊÊÓÃÓÚmssql£©"  µã´ËÔÚGOOGLEËÑË÷¹Ø¼ü×Ö"һЩSelect¼ìË÷¸ß¼¶Ó÷¨£¨ÊÊÓÃÓÚmssql£©"
ÈÈÃÅÎÄÕ£º
  ¡¤¶þ½øÖÆ×ªÊ®½øÖƵÄSQLº¯Êý   ¡¤SQL2005 SSIS
  ¡¤¶ÔÊý¾Ý¿â×Ö¶ÎʹÓÃĬÈÏÖµ   ¡¤exp/impµ¼³öµ¼È빤¾ßµÄʹÓÃ
  ¡¤¾­³£Óõ½µÄ½»²æ±íÎÊÌâ,Ò»°ãÓö¯Ì¬SQLÄÜÉú³É¶¯Ì¬ÁÐ   ¡¤¾«»ªÈ«Ãæ½Ó´¥SQLÓï·¨
  ¡¤ÔÚ´æ´¢¹ý³ÌÖÐÁ¬½ÓÔ¶³ÌÊý¾Ý¿â²¢½øÐвÙ×÷   ¡¤SqlServerµÄ¸üÐÂËø(UPDLOCK)
  ¡¤¼¸ÖÖ·ÖÒ³Ëã·¨¡£·­Ò³±Ø±¸   ¡¤¹ØÓÚSQL Server SQLÓï¾ä²éѯ·ÖÒ³Êý¾ÝµÄ½â¾ö·½°¸

  Ê×Ò³  ËزÄͼƬ  ¸ß¾«Í¼¿â  Ê¸Á¿Í¼¿â  ÍøÒ³ËزĠ ÍøÒ³Ä£°å  ±ÚÖ½  Ã÷ÐÇ  ÏÂÔØ  ½Ì³Ì  ×ÖÌå  Ïã³µÃÀÅ®  QQרÌâ  ÂÛ̳

ÍøÕ¾½éÉÜ | ¹ã¸æÒµÎñ | Éè¼ÆÒµÎñ | ÃâÔðÉùÃ÷ | °æÈ¨ÉùÃ÷ | ÁªÏµÎÒÃÇ|Ìá½»´íÎ󱨸æ
ËØ²ÄÖйú°æÈ¨ËùÓÐ