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

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


Ïà¹ØÎĵµ£º

¶¯Ì¬sqlÓï¾ä»ù±¾Óï·¨

1 :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃExecÖ´ÐÐ
      Àý:      Select * from tableName
                Exec('select * from tableName')
        & ......

SQL Server Óï¾ä²éѯÊÖ²á

½¨±í£º
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 server ÖеÄһЩʵÓõÄsqlÓï¾ä

¼ò½é
ÔÚÕâÆªÎÄÕÂÖУ¬ÎÒÁоÙһЩsqlÓï¾äÀ´½éÉÜÊý¾Ý¿â£¬Êý¾Ý±í£¬ÊÓͼµÈµÈ¡£µ±ÎÒÃÇÔÚʹÓòéѯ²éѯ²Ù×÷ʱÕâЩsqlÓï¾ä¶¼ÊǷdz£ÓÐÓõġ£ËäÈ»ÔÚsql server¶ÔÏóä¯ÀÀÆ÷ÖÐÎÒÃÇÒ²¿ÉÒÔ»ñµÃÕâЩÓï¾ä£¬µ«ÊÇÈç¹ûÎÒÃÇдÕâЩÓï¾äʱÎÒÃÇ¿ÉÒÔ½«Ëü×Ô¶¨Òå¡£Õâ¾ÍÒâζ×ÅÎÒÃÇ¿ÉÒÔ¸øÓè×Ô¼ºµÄÐèÇóÀ´¹ýÂ˽á¹û¡£
sqlÓï¾äÁбí
ÈçºÎÁоÙsql serverµ±Ç°Á ......

SQLÖг£Óú¯ÊýµÄÕûÀí

¶ÔÓÚsqlÖеĺ¯Êý¿ÉνÊǶàµÄ²»Ê¤Ã¶¾Ù£¬±¾ÎÄ´Ó³£Óú¯ÊýµÄ½Ç¶È¶ÔÆäº¯Êý½øÐÐ×ܽ᣺1¡¢ÈÕÆÚºÍʱ¼äº¯Êý2¡¢×Ö·û´®º¯Êý3¡¢ÏµÍ³º¯ÊýÁ÷³Ì¿ØÖÆÓï¾ä
1¡¢  ÈÕÆÚºÍʱ¼äº¯Êý
¶ÔÓÚÈÕÆÚº¯ÊýÎÒÃÇ¿ÉÒÔ·ÖΪ2СÀà½øÐзÖÎö´¦Àí£¬
A¡¢ ÈÕÆÚµÄÕûÌå´¦Àíº¯Êý£¬¾ßÌåµÄº¬ÒåºÍÓï·¨ÈçÏÂËùʾ£º
DATEADD(datepart,number,date)
µÚÒ»¸ö²ÎÊý˵Ã÷ÒªÌí ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ