use YourDataBase
exec sp_fulltext_database 'enable'
create UNIQUE index BestGoodsfull on DataTable(DataTable_primaryID) ----在主键上使用全文索引
exec sp_fulltext_table DataTable,'create','DT_Direct','BestGoodsfull' --选建产全文目录DT_Direct全文目录,
exec sp_fulltext_column 'DataTable','Goods_StartPlace','add' --全文检索的字段
exec sp_fulltext_column 'DataTable','Goods_EndPlace','add' --同上
exec sp_fulltext_table Goods,'activate' --激活全文检索
exec sp_fulltext_catalog 'DT_Direct','start_full' --启动全文检索
/*
exec sp_helpindex DataTable --这个表的所有索引
drop index Goods.upkcl_titledind --如果有不要的全文目录,删除掉
*/