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ÖÐÆ¥Åä×Ö·û´®µÄËÞÖ÷±äÁ¿ÁË¡£
Ò²¾ÍÊÇ˵£¬½«Öն˵õ½µÄÊý¾Ý±ä³ÉÐÎÈç"%*******%%%%%%%%%%"ÕâÑùµÄÆ¥Åä×Ö·û´®£¬ÓÃÓÚÊý¾Ý¿âµÄ²éѯ¡£ÕâÑù£¬¾Í¿ÉÒԳɹ¦µÄʵÏÖ²éѯÊý¾Ý¿âÖиÃÏî°üº¬"******"×Ö·û´®µÄËùÓÐÏî¡£
Ïà¹ØÎĵµ£º
×÷ÖÐÊý¾Ý¿â¾³£³ö´íËÀËø£¬²¢ÇÒ»¹ÒªÒªÇó½â¾öµ±Ç°µÄËÀËø£¬ÎÊÌâ¶à¶à£»
²ÎÕÕCSDN£¬Öйú·ç(Roy)һƪËÀËøÎÄÕ²¢¸Ä½øÁËÏ£»
/***********************************************************************************************************************
ÕûÀíÈË£ººÚľÑÂÉϵÄÎÏÅ£(lenolotus) ÈÕÆÚ:2009.04.28
************ ......
ÉÏ»ØÎÒÃÇ˵µ½ÆÀ¹ÀÒ»ÌõÓï¾äÖ´ÐÐЧÂÊÖ÷Òª¿´Âß¼ IO £¨É¶ÊÇÂß¼ IO £¬É¶ÊÇÎïÀí IO ¼ûÁª»úÎĵµ£©£¬Õâ´ÎÎÒÃǼÌÐø¡£
ÎÒÃÇÏÈ˵˵£¬·µ»Ø¶àÐнá¹ûʱ£¬ÎªÊ²Ã´ SQLServer ÓÐʱ»áÑ¡Ôñ index seek £¬ÓÐʱ»áÑ¡Ôñ index scan ¡£
ÒÔ nonclustered index ΪÀý˵Ã÷¡£
ÏñËùÓеÄË÷Òý B Ê÷Ò»Ñù£¬·Ç¾Û¼¯Ë÷ÒýÊ÷Ò²°üÀ¨ÍêÈ«ÓÉË÷ÒýÊý¾Ý×é³ÉµÄ¸ù½ ......
Ò»¡¢»ù´¡
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¿ª·¢¹ýÈκÎÈí¼þ£¬ÄÇôÄã¿Ï¶¨»áϰ¹ßÓÚʹÓÃËIJ¿·Ö±êʶ·ûÀ´²Î¿¼Ò»¸ö¶ÔÏó£º
[[[server.][database].][schema_name].]object_name
¡¡¡¡ÕýÈçÉÏÃæµÄ·½À¨ºÅËùÏÔʾµÄ£¬¸ÃÓï·¨µÄ²»Í¬²¿·Ö¿ÉÒÔ±»ºöÂÔ£¬Ö»ÒªÄãÌṩ×ã¹»µÄ±í´ïÀ´ÎÞ¶þÒ嵨±êʶÄãµÄ¶ÔÏó¼´¿É¡£ÀýÈ磬ÏÂÃæËùÓÐÕâЩ±í´ï¶¼¿ÉÄܲο¼Ïàͬµ ......
1, ʲôÊÇͳ¼ÆÐÅÏ¢
ÒÔÏÂÊǹٷ½µÄ¶Ôͳ¼ÆÐÅÏ¢µÄÃèÊö£º
°´ÕÕĬÈÏÉèÖã¬Èç¹û±íÖеÄijÁÐûÓÐË÷Òý£¬ÔòSQL Server»á×Ô¶¯Îª¸ÃÁд´½¨Í³¼Æ¡£È»ºó£¬²éѯÓÅ»¯Æ÷ÆÀ¹À¸ÃÁÐÖÐÊý¾Ý·Ö²¼·¶Î§µÄͳ¼ÆÐÅÏ¢£¬ÒÔÑ¡ÔñÒ»¸ö¸üΪÓÐЧµÄ²éѯ´¦Àí·½°¸¡£·Ö±æ×Ô¶¯´´½¨µÄͳ¼ÆºÜ¼òµ¥£¬ÔÚSQL Serve ......