MS SQL SERVER 2005È«ÎÄË÷Òý
MS SQL SERVER 2005È«ÎÄË÷Òýѧϰ±Ê¼ÇÒ»
ÏÈÁ˽âÒ»ÏÂÈ«ÎÄË÷ÒýÊÇÈçºÎ´´½¨ºÍʹÓõÄ
´´½¨È«ÎÄË÷Òý:
ÔÚMS SQL SERVER 2005Àï,È«ÎÄË÷ÒýÊÇÒ»¸öµ¥¶ÀµÄ·þÎñÏî,ĬÈÏÊÇÆô¶¯µÄ,µ«ÊÇûÓÐÔÊÐíÊý¾Ý¿âÆôÓÃÈ«ÎÄË÷Òý,Èç¹ûÒªÔÚij¸öÊý¾Ý¿âÖд´½¨È«ÎÄË÷Òý,ÏÈÒªÆôÓÃÊý¾Ý¿âµÄÈ«ÎÄË÷Òý.
ÆôÓ÷½·¨:
1.Êý¾Ý¿â->ÊôÐÔ->³£¹æ->ÆôÓÃÈ«ÎÄË÷Òý --execute sp_fulltext_database 'enable'
2.ÔÚ²éѯÖÐÖ´ÐÐ:,Èç¹ûûÓÐÆôÓþÍÖ´ÐÐÒÔÉÏÆô¶¯Óï¾ä£¬È»ºó´´½¨Ë÷ÒýĿ¼.
--execute sp_fulltext_catalog 'ft_titles', 'create'
ÆôÓÃÁËË÷ÒýÁË,¾Í¿ÉÒÔ´´½¨Ë÷ÒýĿ¼ÁË
ÔÚ²éѯÖÐÖ´ÐÐÒÔÏÂÓï¾ä:
CREATE FULLTEXT CATALOG Ë÷ÒýĿ¼Ãû
Ö´ÐÐÒÔºó,¾Í»áÔÚSQL SERVERµÄ°²×°Ä¿Â¼Àï¿´µ½Ò»¸öͬÃûµÄĿ¼ÃûÁË,·¾¶ÎªMSSQL.1/MSSQL/FTDATA/Ë÷ÒýĿ¼Ãû
ÿ¸ö±íÖ»¿ÉÒÔÓÐÒ»¸öÈ«ÎÄË÷Òý,´æ·ÅÔÚÖ¸¶¨µÄË÷ÒýĿ¼Àï,¿ÉÒÔͨ¹ýÏòµ¼´´½¨,Ò²¿ÉÒÔͨ¹ýSQL´´½¨
»ù±¾Óï·¨:
CREATE FULLTEXT INDEX ON tablename
£¨Ë÷ÒýÁÐ1,Ë÷ÒýÁÐ2...£©
KEY INDEX indexname ON Ë÷ÒýĿ¼Ãû
indexnameÊÇÖ¸ÒÑ´æÔڵĻùÓÚÖ¸¶¨±íµÄΨһË÷ÒýÃû.¶ø²»ÊÇΨһË÷ÒýÁÐÃû.Èç¹ûË÷Òý²»´æÔÚ,ÐèÒªÏÈ´´½¨Î¨Ò»Ë÷Òý.
ʹÓÃÈ«ÎÄË÷Òý:
Ö÷ҪʹÓÃCONTAINS,FREETEXT½øÐвéѯ
¼ÙÉèÒÑÓÐÒ»¸ö±ímusic,ÒÑΪ×Ö¶Îmemo´´½¨È«ÎÄË÷Òý,ÄÇôҪ²éѯº¬ÓÐÖܽÜÂ×»òÕßjayµÄËùÓмǼµÄÓï¾äΪ:
SELECT * from mu
Ïà¹ØÎĵµ£º
Ò»¡¢¼òµ¥²éѯ
¡¡¡¡ ¼òµ¥µÄTransact-SQL²éѯֻ°üÀ¨Ñ¡ÔñÁÐ±í¡¢from×Ó¾äºÍWHERE×Ӿ䡣
ËüÃÇ·Ö±ð˵Ã÷Ëù²éѯÁС¢²éѯµÄ
±í»òÊÓͼ¡¢ÒÔ¼°ËÑË÷Ìõ¼þµÈ¡£
ÀýÈ磬ÏÂÃæµÄÓï¾ä²éѯtesttable±íÖÐÐÕÃûΪ“ÕÅÈý”µÄnickname×ֶκÍemail×ֶΡ£
SELECT nickname,email
from testtable WHERE name='ÕÅÈý'
(Ò»)Ñ¡ÔñÁбí
¡ ......
ÔÚ·Ö×éÅÅÐò¹ý³ÌÖÐÐèҪн¨ÅÅÐòÁУ¬°´Ìõ¼þ:(ÎïÁÏ·ÖÀà+¿Í»§Ãû³Æ) ½øÐзÖ×é»ã×Ü È»ºó¾Í¸ù¾Ý¸ÃÌõ¼þ½øÐÐÅÅÐò
1.ÐèҪƴ´ÕÁ½ÁÐ ×÷ΪÅÅÐòÁÐ,ÈçÐè¼ÓÈëÌØÊâ×Ö·û.¾Í»á±¨´í.
ÒòΪ±¾Éí¸Ä×ֶξÍÊÇvarcharÀàÐÍ ÐèÒª½«charÀàÐÍ'_' ת»»³Évarchar
2.Æ´´Õ¹ý³ÌÖÐÓпոñÐèҪȥ¿Õ¸ñ
e.g£ºselect (trim(ÎïÁÏ·ÖÀà)+to_char( ......
¼ò½é
ÔÚÕâƪÎÄÕÂÖУ¬ÎÒÁоÙһЩsqlÓï¾äÀ´½éÉÜÊý¾Ý¿â£¬Êý¾Ý±í£¬ÊÓͼµÈµÈ¡£µ±ÎÒÃÇÔÚʹÓòéѯ²éѯ²Ù×÷ʱÕâЩsqlÓï¾ä¶¼ÊǷdz£ÓÐÓõġ£ËäÈ»ÔÚsql server¶ÔÏóä¯ÀÀÆ÷ÖÐÎÒÃÇÒ²¿ÉÒÔ»ñµÃÕâЩÓï¾ä£¬µ«ÊÇÈç¹ûÎÒÃÇдÕâЩÓï¾äʱÎÒÃÇ¿ÉÒÔ½«Ëü×Ô¶¨Òå¡£Õâ¾ÍÒâζ×ÅÎÒÃÇ¿ÉÒÔ¸øÓè×Ô¼ºµÄÐèÇóÀ´¹ýÂ˽á¹û¡£
sqlÓï¾äÁбí
ÈçºÎÁоÙsql serverµ±Ç°Á ......
¡¾ÔÎĵØÖ·¡¿Tip/Trick: Guard Against SQL Injection Attacks
¡¾ÔÎÄ·¢±íÈÕÆÚ¡¿ Saturday, September 30, 2006 9:11 AM
SQL×¢Èë¹¥»÷ÊǷdz£ÁîÈËÌÖÑáµÄ°²È«Â©¶´£¬ÊÇËùÓеÄweb¿ª·¢ÈËÔ±£¬²»¹ÜÊÇʲôƽ̨£¬¼¼Êõ£¬»¹ÊÇÊý¾Ý²ã£¬ÐèҪȷÐÅËûÃÇÀí½âºÍ·ÀÖ¹µÄ¶«Î÷¡£²»ÐÒµÄÊÇ£¬¿ª·¢ÈËÔ±ÍùÍù²»¼¯Öл¨µãʱ¼äÔÚÕâÉÏÃ棬ÒÔÖÁËûÃǵÄÓ¦Ó㬠......