现在的位置: 首页 > 综合 > 正文

Full Text Search in SQL 2005

2011年01月12日 ⁄ 综合 ⁄ 共 780字 ⁄ 字号 评论关闭

I issued the commands

USE MyDatabase
EXEC sp_fulltext_database  'enable'

"At this point, the Full Text Search was available in the Management Console"

From here in TSQL :-

--1  Create the catalog (unless you already have)
EXEC sp_fulltext_catalog   'FTCatalog','create' 
--2 Add a full text index to a table
EXEC sp_fulltext_table     'Departments''create''FTCatalog''pk_departments' 
EXEC sp_fulltext_table     'Employees''create''FTCatalog''pk_employees' 
--3 Add a column to the full text index
EXEC sp_fulltext_column    'Departments''ProductName''add' 
EXEC sp_fulltext_column    'Employees''Description''add' 
--4 Activate the index
1 EXEC sp_fulltext_table     'Departments','activate' 
2 EXEC sp_fulltext_table     'Employees','activate' 
--5 Start full population
EXEC sp_fulltext_catalog   'FTCatalog''start_full' 

抱歉!评论已关闭.