use YourDataBaseexec 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'......
阅读全文