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

SQL²éѯÖеÄתÒå×Ö·û ÀÁèÐÇ¿Õ

Èç¹ûÏë²éÕÒ“_cs”½áβµÄµÄÕË»§
select * from [user] where loginname like '%_cs'ÊDz»Ðеģ¬_ ±»ÈÏΪÊÇÈÎÒâµÄ×Ö·û£¬
ËùÒÔÐèҪתÒå×Ö·û£¬ÓÐÁ½ÖÖд·¨£º
select * from [user] where loginname like '%[_]cs'
select * from [user] where loginname like '%/_cs' escape'/'
ͨÅä·ûº¬Òå
%
°üº¬Áã¸ö»ò¸ü¶à×Ö·ûµÄÈÎÒâ×Ö·û´®¡£
_
Èκε¥¸ö×Ö·û¡£
[ ]
Ö¸¶¨·¶Î§£¨ÀýÈç [a-f]£©»ò¼¯ºÏ£¨ÀýÈç [abcdef]£©ÄÚµÄÈκε¥¸ö×Ö·û¡£
[^]
²»ÔÚÖ¸¶¨·¶Î§£¨ÀýÈç [^a - f]£©»ò¼¯ºÏ£¨ÀýÈç [^abcdef]£©ÄÚµÄÈκε¥¸ö×Ö·û¡£
ÀýÈ磺
LIKE 'Mc%' ½«ËÑË÷ÒÔ×Öĸ Mc ¿ªÍ·µÄËùÓÐ×Ö·û´®£¨Èç McBadden£©¡£
LIKE '%inger' ½«ËÑË÷ÒÔ×Öĸ inger ½áβµÄËùÓÐ×Ö·û´®£¨Èç Ringer¡¢Stringer£©¡£
LIKE '%en%' ½«ËÑË÷ÔÚÈκÎλÖðüº¬×Öĸ en µÄËùÓÐ×Ö·û´®£¨Èç Bennet¡¢Green¡¢McBadden£©¡£
LIKE '_heryl' ½«ËÑË÷ÒÔ×Öĸ heryl ½áβµÄËùÓÐÁù¸ö×ÖĸµÄÃû³Æ£¨Èç Cheryl¡¢Sheryl£©¡£
LIKE '[CK]ars[eo]n' ½«ËÑË÷ÏÂÁÐ×Ö·û´®£ºCarsen¡¢Karsen¡¢Carson ºÍ Karson£¨Èç Carson£©¡£
LIKE '[M-Z]inger' ½«ËÑË÷ÒÔ×Ö·û´® inger ½áβ¡¢ÒÔ´Ó M µ½ Z µÄÈκε¥¸ö×Öĸ¿ªÍ·µÄËùÓÐÃû³Æ£¨Èç Ringer£©¡£
LIKE 'M[^c]%' ½«ËÑË÷ÒÔ×Öĸ M ¿ªÍ·£¬²¢ÇÒµÚ¶þ¸ö×Öĸ²»ÊÇ c µÄËùÓÐÃû³Æ£¨Èç MacFeather£©¡£
ʹÓà ESCAPE ¹Ø¼ü×Ö¶¨ÒåתÒå·û¡£ÔÚģʽÖУ¬µ±×ªÒå·ûÖÃÓÚͨÅä·û֮ǰʱ£¬¸ÃͨÅä·û¾Í½âÊÍΪÆÕͨ×Ö·û¡£ÀýÈ磬ҪËÑË÷ÔÚÈÎÒâλÖðüº¬×Ö·û´® 5% µÄ×Ö·û´®£¬ÇëʹÓãº
WHERE ColumnA LIKE '%5/%%' ESCAPE '/'
·ûºÅº¬Òå
LIKE '5[%]'
5%
LIKE '5%'
5 ºó¸ú 0 ¸ö»ò¸ü¶à×Ö·ûµÄ×Ö·û´®
LIKE '[_]n'
_n
LIKE '_n'
an, in, on (and so on)
LIKE '[a-cdf]'
a, b, c, d, or f
LIKE '[-acdf]'
-, a, c, d, or f
LIKE '[ [ ]'
[
LIKE ']'
]
Àý×Ó£º
select * from T_DataVersion where VersionName like '%2[%]%'
select * from T_DataVersion where VersionName like '%2/%%' ESCAPE '/'
²éÕÒVersionName Öаüº¬2%×Ö·û´®µÄÊý¾Ý
VerSionID UserID VersionName DataCode UpLoadDate IntegerStep
V20081229001 104 V200812%29001 A0001 2009-12-29 00:00:00.000 NULL


Ïà¹ØÎĵµ£º

SQL ServerÊý¾Ý¿âʱ³öÏÖ¹ÂÁ¢Óû§È¨ÏÞÎÊÌâµÄ½â¾ö°ì

--×Ô¼ººÜÓÞ´ÀµÄ×ö·¨£¬ÒÔΪֱ½Óɾ³ýÊý¾Ý¿âÓû§Ãû£¬ÔÙ´Óд´½¨Óû§µÇ¼ÃûºÍÊý¾Ý¿âÓû§Ãû¡£
--×Ô¼ºÒÔΪ¿ÉÒÔÖ±½Ó´´½¨ÓëÖ®Ô­ÏÈÒ»ÑùµÄÊý¾Ý¿âµÇ¼Ãû¾Í¿ÉÒÔ
--µ«ÕâЩ²Ù×÷ÊDz»Æð×÷ÓõÄ
--Ô­Òò
--µ±Ó³Éä¹ÂÁ¢Óû§Ê±£¬Ö÷´ÓÊý¾Ý¿âÖеÄSID½«·ÖÅ䏸¹ÂÁ¢Óû§£¬ËùÒÔÿ´ÎÒ»¸öÊý¾Ý¿â±¸¸½¼Ó»òÕß»¹Ô­Ê±£¬--SIDÔÚSQL Server µÇ¼ÃûºÍÊý¾Ý¿âÓû ......

Èճ̰²ÅÅÉú³ÉµÄsqlÓï¾ä

select *
from
(select [id]=row_number() over (order by getdate()),
        date=convert(varchar(8),dateadd(dd,number,'2010-01-01'),112)
        from
        (select number from master..spt ......

Sql Server ×Ö·û´®¾ÛºÏº¯Êý

 Sql Server ÓÐÈçϼ¸Ö־ۺϺ¯ÊýSUM¡¢AVG¡¢COUNT¡¢COUNT(*)¡¢MAX ºÍ MIN£¬µ«ÊÇÕâЩº¯Êý¶¼Ö»ÄܾۺÏÊýÖµÀàÐÍ£¬ÎÞ·¨¾ÛºÏ×Ö·û´®¡£Èçϱí:AggregationTable
Id Name
1 ÕÔ
2 Ç®
1 Ëï
1 Àî
2 ÖÜ
Èç¹ûÏëµÃµ½ÏÂͼµÄ¾ÛºÏ½á¹û
Id Name
1 ÕÔËïÀî
2 Ç®ÖÜ
ÀûÓÃSUM¡¢AVG¡¢COUNT¡¢COUNT(*)¡¢MAX ºÍ MINÊÇÎÞ·¨×öµ½µ ......

C#ÏîÄ¿´ò°üÒÔ¼°×Ô¶¯°²×°SQL SeverÊý¾Ý¿â


±¾ÎĽ«½éÉÜC#ÏîÄ¿´ò°üÒÔ¼°×Ô¶¯°²×°SQL SeverÊý¾Ý¿â£¬°üÀ¨´´½¨²¿ÊðÏîÄ¿¡¢½«Ö÷³ÌÐòÏîÄ¿µÄÊä³öÌí¼Óµ½²¿ÊðÏîÄ¿ÖС¢´´½¨°²×°³ÌÐòÀà¡¢´´½¨×Ô¶¨Òå°²×°¶Ô»°¿òµÈµÈ¡£
 
’power by: landlordh   
’for 2000,xp,2003   
Module uninstall   
Sub Main ......

SQL*PlusµÄ³£ÓÃÃüÁî

Á¬½ÓÃüÁî
1.CONNECT(CONN)£º½¨Á¢Óû§Á¬½Ó
Óï·¨£ºCONNECT [USERNAME]/[password][@connect_identifier]
²ÎÊý£ºUSERNAME£ºÓû§Ãû£»  password£ºÃÜÂ룻  connect_identifier£ºÊý¾Ý¿âʵÀýÃû
ÀýÈ磺CONNECT scott/tiger@ORCL
×¢Ò⣺Èç¹ûÒªÒÔÌØÈ¨Óû§Éí·ÝÁ¬½Ó£¬Ôò±ØÐë´ø£ºAS SYSDBA »ò AS SYSOPERÑ¡Ï
ÀýÈ磺CO ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ