SQL SERVERÖÐÈ«ÎļìË÷µÄ´´½¨ÓëÓ¦ÓÃ
È«ÎÄËÑË÷µÄºËÐÄÒýÇ潨Á¢ÔÚMicrosoft Full-Text Engine for SQL Server (MSFTESQL) ·þÎñÌṩ֧³Ö
Ãæ¶Ôº£Á¿µÄÊý¾Ý£¬ÈçºÎ²ÅÄÜÕÒµ½ÎÒÐèÒªµÄ£¿¶ÔÊý°ÙÍòÐÐÎı¾Êý¾ÝÖ´ÐеÄLIKE ²éѯ¿ÉÄÜÐèÒª»¨·Ñ¼¸·ÖÖÓʱ¼ä²ÅÄÜ·µ»Ø½á¹û£»µ«¶ÔͬÑùµÄÊý¾Ý£¬È«ÎIJéѯֻÐèÒª¼¸Ãë»ò¸üÉÙµÄʱ¼ä£¬¾ßÌåÈ¡¾öÓÚ·µ»ØµÄÐÐÊý£¬È«ÎļìË÷ÌṩÁËÒ»ÖÖ±ã½ÝµÄ·½Ê½£¬ÇáËɵØÈÃËùÐèÊý¾ÝÊÖµ½ÇÜÀ´¡£
ÏÂÃæ½éÉÜÈ«ÎÄËÑË÷µÄ´´½¨ÓëÓ¦Óãº
1¡¢È«ÎļìË÷µÄ´´½¨
use test
exec sp_fulltext_database 'enable'
-- FullTextNameÊDZ£´æË÷ÒýÎļþµÄÎļþ¼Ð(Êý¾Ý¿âÉÏÌåÏÖÊÇ:È«ÎÄĿ¼Ãû)
-- create±íʾ´´½¨
-- E:\SQL2005FullText±íʾFullTextNameÎļþ¼ÐµÄ¸ù·¾¶
exec sp_fulltext_catalog 'FullTextName', 'create', 'E:\SQL2005FullText'
-- ¶ÔNews±í´´½¨È«ÎÄËÑË÷
-- PK_NewsÊDZíµÄÓÐЧË÷Òý(Ò»°ãÓÃÖ÷¼üË÷ÒýÃû)
exec sp_fulltext_table 'News', 'create', 'FullTextName','PK_News' --ÔÚÒÑÓеıíÉϸù¾ÝÒÑÓеÄË÷Òý´´½¨È«ÎÄË÷Òý
-- NewsContentÊÇÒª´´½¨È«ÎÄËÑË÷µÄÁÐÃû
-- 0x0804´ú±í¼òÌåÖÐÎĵÄlocal ID
exec sp_fulltext_column 'News', 'NewsContent', 'add',0x0804
exec sp_fulltext_column 'News', 'NewsTitle', 'add',0x0804
-- ±íÆô¶¯ÍêÈ«Ìî³ä(Ò»°ãÓÃÓÚµÚÒ»´ÎÉú³ÉÈ«ÎļìË÷ʱӦÓÃ)
exec sp_fulltext_table 'News', 'start_full'
2¡¢Ò»µ©ÉèÖúÃÈ«ÎļìË÷£¬ÄãÐèÒª×Ô¼ºÀ´Î¬»¤È«ÎÄË÷ÒýµÄ¸üй¤×÷£¬ÕâÊÇÒòΪȫÎÄĿ¼µÄ¸üв»ÊÇ×Ô¶¯½øÐеġ£
-- ÔöÁ¿Ìî³ä(±íÖбØÐëÓÐÒ»¸öʱ¼ä´Á×ֶΣ¬·ñÔòËü½«×ª»»ÎªÍêÈ«Ìî³ä)
-- ¿ÉÒÔʹÓÃSQL ServerµÄAgentÖƶ¨Ò»¸ö¸üеļƻ®£¬¶¨Ê±¶ÔË÷Òý×öÔöÁ¿Ìî³ä
EXEC sp_fulltext_catalog 'FullTextName','start_incremental'
-- Æô¶¯¸ü¸Ä¸ú×ÙÌî³ä
exec sp_fulltext_table 'News','start_change_tracking'
exec sp_fulltext_table 'News','Start_background_updateindex'
´´½¨ÍêÈ«ÎļìË÷ºó£¬¾Í¿ÉÒÔÓÃËĸöCONTAINS, FREETEXT,CONTAINSTABLE, FREETEXTTABLEν´Ê½øÐвéѯ
3¡¢ÐÔÄÜ
È«ÎļìË÷µÄÌî³äºÍ²éѯ¶¼ÐèÒª»¨·Ñϵͳ¿ªÏú£¬Ê¹ÓÃÈ«ÎļìË÷£¬ÄãÐèÒª¿¼ÂÇÐÔÄÜÉϵÄÎÊÌ⣬ijһÖÖ·½·¨±ÈÁíÍâÒ»ÖÖ·½·¨ºÃ²¢Ã»ÓÐÒ»¸ö¾ø¶ÔµÄÆÀÅбê×¼¡£ÄãÐèÒª¸ù¾Ý¾ßÌåÇé¿ö×Ô¼ºÀ´¶Ô±È²»Í¬·½·¨µÄÓÅÁÓ¡£²»¹ý»¹ÊÇÓÐһЩ½¨Ò飺
&
Ïà¹ØÎĵµ£º
1¡¢ISNULL ( check_expression , replacement_value )
²ÎÊý
check_expression
½«±»¼ì²éÊÇ·ñΪ NULLµÄ±í´ïʽ¡£check_expression ¿ÉÒÔÊÇÈκÎÀàÐ͵ġ£
replacement_valueÔÚ check_expressionΪNULLʱ½«·µ»ØµÄ±í´ïʽ¡£replacement_value ±ØÐëÓë check_expresssion ¾ßÓÐÏàͬµÄÀàÐÍ¡£
·µ»ØÀàÐÍ
·µ»ØÓë check_expression Ï ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡¡¡1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
......
1.³£Á¿
¶¨ÒåÓï·¨¸ñʽ£º
³£Á¿Ãû constant ÀàÐͱêʶ·û [not null]:=Öµ;
È磺PI constant number(9):=3.1415;
2.»ù±¾Êý¾ÝÀàÐͱäÁ¿
»ù±¾Êý¾ÝÀàÐÍ
number Êý×ÖÐÍ
int ÕûÊýÐÍ
pls_integer ÕûÊýÐÍ£¬²úÉúÒç³öʱ³öÏÖ´íÎó
binary_integer ÕûÊýÐÍ£¬±íʾ´ø·ûºÅµÄÕûÊý
char ¶¨³¤×Ö·ûÐÍ£¬×î´ó255¸ö×Ö·û
varchar2 ±ä³¤× ......
ÊÂÎñÊÇOracle9iÖнøÐÐÊý¾Ý¿â²Ù×÷µÄ»ù±¾µ¥Î»£¬ÔÚPL/SQL³ÌÐòÖУ¬¿ÉÒÔʹÓÃ3¸öÊÂÎñ´¦Àí¿ØÖÆÃüÁî¡£
1. commitÃüÁî
commitÊÇÊÂÎñÌá½»ÃüÁî¡£Oracle9iÊý¾Ý¿âÖУ¬Îª±£Ö¤Êý¾ÝÒ»ÖÂÐÔ£¬ÔÚÄÚ´æÖÐΪÿ¸ö¿Í»§»ú½¨Á¢¹¤×÷Çø£¬¿Í»§»ú¶ÔÊý¾Ý¿â½øÐвÙ×÷µÄÊÂÎñ¶¼ÔÚ¹¤×÷ÇøÍê³É£¬Ö»ÓÐÖ´ÐÐcommitÃüÁîºó£¬¹¤×÷ÇøÄÚµÄÐÞ¸ÄÄÚÈݲÅдÈëµ½Êý¾Ý¿âÉÏ£¬³Æ ......
What is SQL*Plus and where does it come from?
SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers ......