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
Ïà¹ØÎĵµ£º
1 :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃExecÖ´ÐÐ
Àý: Select * from tableName
Exec('select * from tableName')
& ......
½¨±í£º
CREATE TABLE [DB.dbo].tableName
(Stud_id int CONSTRAINT constraintName1 not null primary key,
Name nvarchar(5) not null,
Birthday datetime,
Gender nchar(1),
Telcode char(12),
Zipcode char(6) CONSTRAINT constraintName2 CHECK(zipcode like [ ......
¼ò½é
ÔÚÕâÆªÎÄÕÂÖУ¬ÎÒÁоÙһЩsqlÓï¾äÀ´½éÉÜÊý¾Ý¿â£¬Êý¾Ý±í£¬ÊÓͼµÈµÈ¡£µ±ÎÒÃÇÔÚʹÓòéѯ²éѯ²Ù×÷ʱÕâЩsqlÓï¾ä¶¼ÊǷdz£ÓÐÓõġ£ËäÈ»ÔÚsql server¶ÔÏóä¯ÀÀÆ÷ÖÐÎÒÃÇÒ²¿ÉÒÔ»ñµÃÕâЩÓï¾ä£¬µ«ÊÇÈç¹ûÎÒÃÇдÕâЩÓï¾äʱÎÒÃÇ¿ÉÒÔ½«Ëü×Ô¶¨Òå¡£Õâ¾ÍÒâζ×ÅÎÒÃÇ¿ÉÒÔ¸øÓè×Ô¼ºµÄÐèÇóÀ´¹ýÂ˽á¹û¡£
sqlÓï¾äÁбí
ÈçºÎÁоÙsql serverµ±Ç°Á ......
¶ÔÓÚsqlÖеĺ¯Êý¿ÉνÊǶàµÄ²»Ê¤Ã¶¾Ù£¬±¾ÎÄ´Ó³£Óú¯ÊýµÄ½Ç¶È¶ÔÆäº¯Êý½øÐÐ×ܽ᣺1¡¢ÈÕÆÚºÍʱ¼äº¯Êý2¡¢×Ö·û´®º¯Êý3¡¢ÏµÍ³º¯ÊýÁ÷³Ì¿ØÖÆÓï¾ä
1¡¢ ÈÕÆÚºÍʱ¼äº¯Êý
¶ÔÓÚÈÕÆÚº¯ÊýÎÒÃÇ¿ÉÒÔ·ÖΪ2СÀà½øÐзÖÎö´¦Àí£¬
A¡¢ ÈÕÆÚµÄÕûÌå´¦Àíº¯Êý£¬¾ßÌåµÄº¬ÒåºÍÓï·¨ÈçÏÂËùʾ£º
DATEADD(datepart,number,date)
µÚÒ»¸ö²ÎÊý˵Ã÷ÒªÌí ......