语源科技BlogJava-春分.夏至.立秋.冬至http://www.blogjava.net/CUGBWEI/zh-cnThu, 07 May 2026 01:01:15 GMTThu, 07 May 2026 01:01:15 GMT60Microsoft SQL Server 2000全文检索建立以及使用http://www.blogjava.net/CUGBWEI/archive/2005/07/26/8491.html阿威阿威Tue, 26 Jul 2005 08:34:00 GMThttp://www.blogjava.net/CUGBWEI/archive/2005/07/26/8491.htmlhttp://www.blogjava.net/CUGBWEI/comments/8491.htmlhttp://www.blogjava.net/CUGBWEI/archive/2005/07/26/8491.html#Feedback0http://www.blogjava.net/CUGBWEI/comments/commentRss/8491.htmlhttp://www.blogjava.net/CUGBWEI/services/trackbacks/8491.htmlexec sp_fulltext_database 'enable'
/*建立全文检索目录*/
exec sp_fulltext_catalog 'CONTENTMANAGER_CONTENTTEXT_FT', 'create'
/*在全文检索目录中注册进行全文检索的表*/
exec sp_fulltext_table 'JOINKEYDOCCONTENT', 'create', 'CONTENTMANAGER_CONTENTTEXT_FT', 'PK_JOINKEYDOCCONTENT'
/*设置全文检索列名*/
exec sp_fulltext_column 'JOINKEYDOCCONTENT', 'CONTENTTEXT', 'ADD'
/*建立全文索引*/
exec sp_fulltext_table 'JOINKEYDOCCONTENT', 'ACTIVATE'
/*填充全文索引目录*/
exec sp_fulltext_catalog 'CONTENTMANAGER_CONTENTTEXT_FT', 'START_FULL'
/*使用全文索引*/
/*CONTAINS语句*/
SELECT CONTENTID FROM JOINKEYDOCCONTENT WHERE CONTAINS(CONTENTTEXT, 'EXE')
/*FREETEXT语句*/
SELECT CONTENTID FROM JOINKEYDOCCONTENT WHERE FREETEXT(*, 'EXE')
GO

阿威 2005-07-26 16:34 发表评论
]]>