Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÐÔÄÜ·ÖÎö ËÀËø¼ì²âÊý¾Ý¿â×èÈûÓï¾ä

×÷ÖÐÊý¾Ý¿â¾­³£³ö´íËÀËø£¬²¢ÇÒ»¹ÒªÒªÇó½â¾öµ±Ç°µÄËÀËø£¬ÎÊÌâ¶à¶à£»
²ÎÕÕCSDN£¬Öйú·ç(Roy)һƪËÀËøÎÄÕ²¢¸Ä½øÁËÏ£»
/***********************************************************************************************************************
ÕûÀíÈË£ººÚľÑÂÉϵÄÎÏÅ£(lenolotus) ÈÕÆÚ:2009.04.28
************ ......

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

ÉÏ»ØÎÒÃÇ˵µ½ÆÀ¹ÀÒ»ÌõÓï¾äÖ´ÐÐЧÂÊÖ÷Òª¿´Âß¼­ IO £¨É¶ÊÇÂß¼­ IO £¬É¶ÊÇÎïÀí IO ¼ûÁª»úÎĵµ£©£¬Õâ´ÎÎÒÃǼÌÐø¡£
ÎÒÃÇÏÈ˵˵£¬·µ»Ø¶àÐнá¹ûʱ£¬ÎªÊ²Ã´ SQLServer ÓÐʱ»áÑ¡Ôñ index seek £¬ÓÐʱ»áÑ¡Ôñ index scan ¡£
ÒÔ nonclustered index ΪÀý˵Ã÷¡£
ÏñËùÓеÄË÷Òý B Ê÷Ò»Ñù£¬·Ç¾Û¼¯Ë÷ÒýÊ÷Ò²°üÀ¨ÍêÈ«ÓÉË÷ÒýÊý¾Ý×é³ÉµÄ¸ù½ ......

¾­µäSQLÓï¾ä

 Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack ......

ÀûÓÃͬÒå´Ê¼ò»¯SQL Server 2005¿ª·¢

Ò». ÒýÑÔ
¡¡¡¡Èç¹ûÄãÔø¾­Ê¹ÓÃSQL Server¿ª·¢¹ýÈκÎÈí¼þ£¬ÄÇôÄã¿Ï¶¨»áϰ¹ßÓÚʹÓÃËIJ¿·Ö±êʶ·ûÀ´²Î¿¼Ò»¸ö¶ÔÏó£º
[[[server.][database].][schema_name].]object_name
¡¡¡¡ÕýÈçÉÏÃæµÄ·½À¨ºÅËùÏÔʾµÄ£¬¸ÃÓï·¨µÄ²»Í¬²¿·Ö¿ÉÒÔ±»ºöÂÔ£¬Ö»ÒªÄãÌṩ×ã¹»µÄ±í´ïÀ´ÎÞ¶þÒ嵨±êʶÄãµÄ¶ÔÏó¼´¿É¡£ÀýÈ磬ÏÂÃæËùÓÐÕâЩ±í´ï¶¼¿ÉÄܲο¼Ïàͬµ ......

Sql Server 2005 ͳ¼ÆÐÅÏ¢ÓÃ;

1, ʲôÊÇͳ¼ÆÐÅÏ¢ 
    ÒÔÏÂÊǹٷ½µÄ¶Ôͳ¼ÆÐÅÏ¢µÄÃèÊö£º
     °´ÕÕĬÈÏÉèÖã¬Èç¹û±íÖеÄijÁÐûÓÐË÷Òý£¬ÔòSQL Server»á×Ô¶¯Îª¸ÃÁд´½¨Í³¼Æ¡£È»ºó£¬²éѯÓÅ»¯Æ÷ÆÀ¹À¸ÃÁÐÖÐÊý¾Ý·Ö²¼·¶Î§µÄͳ¼ÆÐÅÏ¢£¬ÒÔÑ¡ÔñÒ»¸ö¸üΪÓÐЧµÄ²éѯ´¦Àí·½°¸¡£·Ö±æ×Ô¶¯´´½¨µÄͳ¼ÆºÜ¼òµ¥£¬ÔÚSQL Serve ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ