Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL LIKE ͨÅä·ûËæ±Ê £¨SqlServer£©

ͨÅä·û ˵Ã÷
_    ÓëÈÎÒâµ¥×Ö·ûÆ¥Åä
 
%    Óë°üº¬Ò»¸ö»ò¶à¸ö×Ö·ûµÄ×Ö·û´®Æ¥Åä
 
[ ]  ÓëÌØ¶¨·¶Î§£¨ÀýÈ磬[a-f]£©»òÌØ¶¨¼¯£¨ÀýÈ磬[abcdef]£©ÖеÄÈÎÒâµ¥×Ö·ûÆ¥Åä¡£
 
[^]  ÓëÌØ¶¨·¶Î§£¨ÀýÈ磬[^a-f]£©»òÌØ¶¨¼¯£¨ÀýÈ磬[^abcdef]£©Ö®ÍâµÄÈÎÒâµ¥×Ö·ûÆ¥Åä¡£
 
Àý×Ó:
• WHERE FirstName LIKE '_im' ¿ÉÒÔÕÒµ½ËùÓÐÈý¸ö×ÖĸµÄ¡¢ÒÔ im ½áβµÄÃû×Ö£¨ÀýÈ磬Jim¡¢Tim£©¡£
 
• WHERE LastName LIKE '%stein' ¿ÉÒÔÕÒµ½ÐÕÒÔ stein ½áβµÄËùÓÐÔ±¹¤¡£
 
• WHERE LastName LIKE '%stein%' ¿ÉÒÔÕÒµ½ÐÕÖÐÈÎÒâλÖðüÀ¨ stein µÄËùÓÐÔ±¹¤¡£
 
• WHERE FirstName LIKE '[JT]im' ¿ÉÒÔÕÒµ½Èý¸ö×ÖĸµÄ¡¢ÒÔ im ½áβ²¢ÒÔ J »ò T ¿ªÊ¼µÄÃû×Ö£¨¼´½öÓÐ Jim ºÍ Tim£©
 
• WHERE LastName LIKE 'm[^c]%' ¿ÉÒÔÕÒµ½ÒÔ m ¿ªÊ¼µÄ¡¢ºóÃæµÄ£¨µÚ¶þ¸ö£©×Öĸ²»Îª c µÄËùÓÐÐÕ¡£


Ïà¹ØÎĵµ£º

SQL Server½Ì³Ì:¶ÁÈ¡µÚÈý·½Êý¾Ý¿âµÄÊý¾Ý

×÷Õß: cnd8, ¡¡³ö´¦:ITר¼ÒÍøÂÛ̳,¡¡ÔðÈα༭: ³Â×Óç÷,¡¡2010-04-21 13:00 ¡¡¡¡ÏÖÔÚÐèÒªÔÚһ̨·þÎñÆ÷(A)ÉϵÄÊý¾Ý¿â(Master)Àï·ÃÎÊÁíÍâһ̨·þÎñÆ÷(B)µÄÁíÍâÁ½¸öÊý¾Ý¿â(NZ ºÍ AU)¡£AU ºÍ NZ ÊÇÍøÕ¾µÄ²¿·ÖʵʱÊý¾Ý£¬Ä¿Ç°Ä³Ò»²½²Ù×÷µÄREPLICATION·½°¸ÊÇ´Ó·þÎñÆ÷Bµ½A£¬AU / NZ µÄ±í½á¹¹Í¬Master Êý¾Ý½á¹¹»ù±¾Ò»Ö¡£¡¡¡¡ÏÖÔÚÐèÒªÔ ......

д³ö¸ßÐÔÄÜSQLÓï¾äµÄ35Ìõ·½·¨·ÖÎö

¡¡¡¡(1)ÕûºÏ¼òµ¥,ÎÞ¹ØÁªµÄÊý¾Ý¿â·ÃÎÊ£º
¡¡¡¡Èç¹ûÄãÓм¸¸ö¼òµ¥µÄÊý¾Ý¿â²éѯÓï¾ä,Äã¿ÉÒÔ°ÑËüÃÇÕûºÏµ½Ò»¸ö²éѯÖÐ(¼´Ê¹ËüÃÇÖ®¼äûÓйØÏµ)
¡¡¡¡(2)ɾ³ýÖØ¸´¼Ç¼£º
¡¡¡¡×î¸ßЧµÄɾ³ýÖØ¸´¼Ç¼·½·¨ ( ÒòΪʹÓÃÁËROWID)Àý×Ó£º
¡¡¡¡DELETE from EMP E WHERE E.ROWID > (SELECT MIN(X. ......

SQL SERVERÏÂͼƬµÄ²åÈëÓë¶ÁÈ¡

ÏÂÎçÏòÊý¾Ý¿âSQL SERVERÖÐÓöµ½Ìí¼ÓͼƬÀàÐÍÊý¾ÝµÄÎÊÌ⣬±¾ÒÔΪÔÚ½çÃæ¹ÜÀíÆ÷ÖпÉÒÔÖ±½Ó£¨Í¨¹ýÖ¸¶¨Â·¾¶°ÑͼƬµÄÊý¾Ý±£´æÆðÀ´£©Ìí¼ÓͼƬȴ²»È»¡£ÍøÉÏËÑÁËÏÂÕÒµ½ÁËÏà¹ØµÄ½ÏרҵµÄ×ÊÁÏ£¬ÕûºÏ½â¶Áһϣº Á½ÖÖ·½·¨£º       µÚÒ»¾ÍÊÇÔÚÊý¾Ý¿âÖд洢ͼƬµÄ·¾¶£¬È»ºóÔÚ³ÌÐòÖиù¾Ý¶ÁÈ¡µÄ·¾¶¶ÁȡͼƬ£»ÕâÖ ......

SQLServer ʹÓñ¸·Ý»¹Ô­Ôì³É¹ÂÁ¢Óû§µÄ½â¾ö

     ÔÚʹÓÃÊý¾Ý¿âµÄ¹ý³ÌÖУ¬¾­³£»áÓöµ½Êý¾Ý¿âÇ¨ÒÆ»òÕßÊý¾ÝÇ¨ÒÆµÄÎÊÌ⣬»òÕßÓÐͻȻµÄÊý¾Ý¿âË𻵣¬ÕâʱÐèÒª´ÓÊý¾Ý¿âµÄ±¸·ÝÖÐÖ±½Ó»Ö¸´¡£µ«ÊÇ£¬´Ëʱ»á³öÏÖÎÊÌ⣬ÕâÀï˵Ã÷¼¸ÖÖ³£¼ûÎÊÌâµÄ½â¾ö·½·¨¡£ 
¹ÂÁ¢Óû§µÄÎÊÌâ
        ±ÈÈ磬ÒÔǰµÄÊý¾Ý¿âµÄºÜ¶à ......

SQL DateTime²éѯÓë¸ñʽ

select * from orders where month(orderdate)= (select month(orderdate) from orders where orderid=10248)
1.Ò»¸öÔµÚÒ»ÌìµÄ
Select DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
2.±¾ÖܵÄÐÇÆÚÒ»
Select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)
3.Ò»ÄêµÄµÚÒ»Ìì
Select DATEADD(yy, DATEDIFF(yy,0,getdate()), 0) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ