sql 2005中全文索引的使用
/*打开全文索引支持，启动SQL Server的全文搜索服务 */execute sp_fulltext_database ‘enable’ /*创建全文目录*/EXEC SP_FULLTEXT_CATALOG 'FT_testData','CREATE'/*建立全文索引数据元*/EXEC sp_fulltext_table 'Hc_Book_Book','CREATE','FT_testData','PK_Hc_Book_BookInfo'/*添加支持全文索引的列名*/EXEC sp_fulltext_column 'Hc_Book_Book','BookName','add'EXEC sp_fulltext_column 'Hc_Book_Book','BookISBN','add'/*为表创建(激活)全文索引*/EXEC sp_fulltext_table 'Hc_Book_Book','activate'/*启动对全文目录的完全填充*/EXEC sp_fulltext_catalog 'FT_testData','start_full'/*验证全文目录填充的进度*/select fulltextcatalogproperty('FT_testData','populateStatus') select * FROM Hc_Book_Book WHERE CONTAINS(BookName,'java')?