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

cobolдsqlÃüÁî

SQLÖÐWHERE×Ó¾äÖпÉÒÔÀûÓÃLIKEÀ´Æ¥ÅäÏàËÆµÄÊý¾ÝÏµ±Ê±Îҵõ½µÄ½áÂÛÊÇ¿ÉÒÔʹÓÃ"%"À´Æ¥Åä×Ö·û´®£¬ÔÚSPUFIÖÐʹÓ㬵ÄÈ·¿ÉÒԵõ½×Ö·û´®Æ¥ÅäµÄЧ¹û¡£È磺
    SELECT * from TEST
          WHERE TESTID LIKE "CZX%";
    ÉÏÃæÕâ¾äÔÚSPUFIÖÐÌá½»Ö´Ðк󣬾ͿÉÒÔ½«TEST±íÖÐËùÓÐTESTIDÖÐËùÓÐÒÔ"CZX"×Ö·û´®¿ªÍ·µÄÏî¶¼ÕÒµ½¡£
    È»¶ø£¬ÔÚCOBOLÖÐÖ´ÐÐǶÈëµÄSQLÓï¾äµÄʱºò£¬"%"¾ÍÖ»ÄÜÆ¥ÅäÒ»¸ö»ò¿ÕµÄ×Ö·ûÁË£¬È磺
    EXEC SQL
         SELECT * from TEST
                WHERE TESTID LIKE "CZX%"
    END-EXEC.
    ¾ÍÖ»Äܲéѯ³öÒÔ"CZX"¿ªÍ·µÄÇÒ×îºó³¤¶È²»³¬¹ý4µÄÏî¡£
    Ò»¿ªÊ¼µÄʱºòÎÒ²¢Ã»ÓÐ×¢Òâµ½Õâ¸öÎÊÌ⣬Òò´Ë£¬ÔÚÆ¥Åä×Ö·û´®µÄʱºò£¬ÀÏÊDzéѯ²»µ½Ô¤ÆÚµÄÊý¾Ý¡£µ±ÎÒ×îÖÕ·¢ÏÖÕâ¸öÎÊÌâµÄʱºò£¬Ò²Ã»ÕÒµ½¸ÃÓÃʲô·ûºÅÀ´Æ¥Åä×Ö·û´®£¬×îºó£¬ÏëÁËÒ»¸öÀûÓÃ"%"À´Íê³É×Ö·û´®Æ¥ÅäµÄ·½·¨£º
    1¡¢ÉùÃ÷Ò»¸ö×Ö·û´®Æ¥ÅäµÄ±äÁ¿£¬³¤¶ÈΪÊý¾Ý¿âÖÐҪƥÅäÏ¶È+2£¬È磺TESTID-FILTERÈ«²¿´æ·Å"%"£»
    2¡¢½«´ÓÖÕ¶Ë»ñµÃµÄɸѡ×Ö·û´®,ÈçTESTID-INPUTÈ¥µô¿Õ¸ñºó£¬²åÈëµ½1Öж¨ÒåµÄ±äÁ¿µÄµÚ¶þλ£»
    3¡¢µÃµ½×Ö·û´®TESTID-FILTER¾ÍÊÇÓÃÔÚLIKEÖÐÆ¥Åä×Ö·û´®µÄËÞÖ÷±äÁ¿ÁË¡£
    Ò²¾ÍÊÇ˵£¬½«Öն˵õ½µÄÊý¾Ý±ä³ÉÐÎÈç"%*******%%%%%%%%%%"ÕâÑùµÄÆ¥Åä×Ö·û´®£¬ÓÃÓÚÊý¾Ý¿âµÄ²éѯ¡£ÕâÑù£¬¾Í¿ÉÒԳɹ¦µÄʵÏÖ²éѯÊý¾Ý¿âÖиÃÏî°üº¬"******"×Ö·û´®µÄËùÓÐÏî¡£


Ïà¹ØÎĵµ£º

ÇåÀíSQL Server 2008Êý¾Ý¿âÈÕÖ¾

µÚÒ»²½, ÔÚÊÕËõǰÏȲ鿴ÈÕÖ¾µÄ´óС:
SELECT *
from sysfiles
WHERE name LIKE ' % LOG %'
GO
µÚ¶þ²½, °ÑÊý¾Ý¿âµÄ»Ö¸´Ä£Ê½Éè³É”¼òµ¥”:
ALTER DATABASE ¿âÃû SET RECOVERY SIMPLE
GO
µÚÈý²½, ÔËÐÐcheckpointÖ¸Áî, °Ñdirty pageд½øÊý¾Ý¿â:
CHECKPOINT
GO
µÚËIJ½, ½Ø¶ÏÈÕÖ¾: 
BACKUP ......

DB2 SQLÐÔÄÜÓÅ»¯Ïà¹ØµÄ10´óÒªËØ

ÏÂÃæÌá³öÁË10ÌõºÍDB2 SQLÐÔÄÜÏà¹ØµÄ10ÌõÒòËØ£º
1¡¢ÌṩÊʵ±µÄͳ¼ÆÐÅÏ¢
¶ÔDB2ÓÅ»¯¹ÜÀíÆ÷£¨otimizer£©¶øÑÔ£¬ÈçºÎ¸ü¼ÓÓÐЧµÄÖ´ÐÐSQLÓï¾äÊÇÓÉ´æÔÚÓÚDB2 catalogÖеÄͳ¼ÆÐÅÏ¢¾ö¶¨µÄ£¬ÓÅ»¯Æ÷ÀûÓÃÕâЩÐÅÏ¢¾ö¶¨×îÓÅ»¯µÄ·¾¶¡£
Òò´Ë£¬ÎªÁ˱£³ÖϵͳÄܹ»×ö³ö×î¼ÑÑ¡Ôñ£¬ÐèÒª¾­³£µÄÔËÐÐRunstatsÃüÁÀ´±£³Öϵͳͳ¼ÆÐÅÏ¢µÄ¼°Ê±ÓÐЧ¡£Ô ......

¸ßЧSQL²éѯ֮Ë÷Òý£¨III£©

ÏÈ˵˵ÕâЩÎóÇø¡£Ëùν“ÎóÇø”£¬ÓÐһЩÊÇÐÂÊÖºÜÈÝÒ×·¸µÄ´íÎó»òÕߺÜÈÝÒ׺öÂÔµÄÎÊÌ⣬ÁíÍâһЩ£¬ÔòÊÇÏñ“ºÄ×Ó³ÔÁËÑλá±ä³Éòùòð”Ò»Ñù£¬ÈÃÎÒÃÇ´ÓС¾ÍÈÏΪÊÇÕýÈ·µÄÊÂÇé¡£ÈçÏ£º
1¡¢   ±íÉϲ»¹ÜÓõÃ×ÅÓò»×Å£¬¶¼¼Ó¸ö¾Û¼¯Ë÷Òý¡£
ÎÒÃÇÖªµÀ£¬±íÒÔÁ½ÖÖ·½Ê½×éÖ¯ÎïÀí´æ´¢£ºÓоۼ¯Ë÷ÒýµÄ“¾Û¼¯± ......

ʵÏÖSQL Server 2008Êý¾ÝѹËõ

ΪʲôÐèÒªÊý¾ÝѹËõ
¡¡¡¡Ê×ÏÈ¿ÉÄÜÐèÒªÌÖÂÛµÄÎÊÌâ¾ÍÊÇΪʲôÔÚ´æ´¢³É±¾²»¶Ï½µµÍµÄ½ñÌ죬΢Èí»¹ÒªÉ··Ñ¿àÐĵØÔÚSQL ServerÖÐʵÏÖ²¢ÇÒ²»¶Ï¸Ä½øÊý¾ÝѹËõ¼¼ÊõÄØ?
¡¡¡¡¾¡¹Ü´æ´¢³É±¾ÒѾ­²»ÔÙÊÇ´«Í³ÒâÒåÉϵÄÊ×Òª¿¼ÂÇÒòËØ£¬µ«ÊÇÕâ²¢²»´ú±íÊý¾Ý¿â³ß´ç²»ÊÇÒ»¸öÎÊÌ⣬ÒòΪÊý¾Ý¿â³ß´ç³ýÁË»áÓ°Ïìµ½´æ´¢³É±¾Ö®Í⣬»¹¼«´óµØ¹ØÁªµ½¹ÜÀí³É±¾º ......

ÔÚ´ò°ü³ÌÐòÖÐ×Ô¶¯°²×°SQL ServerÊý¾Ý¿â

1¡¢´´½¨°²×°ÏîÄ¿“Setup1”°²×°ÏîÄ¿
ÔÚ“Îļþ”²Ëµ¥ÉÏÖ¸Ïò“Ìí¼ÓÏîÄ¿”£¬È»ºóÑ¡Ôñ“н¨ÏîÄ¿”¡£
ÔÚ“Ìí¼ÓÐÂÏîÄ¿”¶Ô»°¿òÖУ¬Ñ¡Ôñ“ÏîÄ¿ÀàÐÍ”´°¸ñÖеē°²×°ºÍ²¿ÊðÏîÄ¿”£¬È»ºóÑ¡Ôñ“Ä£°å”´°¸ñÖеē°²×°ÏîÄ¿”¡£ÔÚ&ldquo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ