sqlServer2000创建全文索引

发布时间：2020-12-12 15:15:35 所属栏目：MsSql教程来源：网络整理

导读：exec sp_fulltext_database 'enable' exec sp_fulltext_catalog 'XX','create' ? exec sp_fulltext_table 'ArticleInfo','create','XX','pk_articleInfo_1' exec sp_fulltext_column 'ArticleInfo','content','add' exec sp_fulltext_column 'ArticleInfo','

exec sp_fulltext_database 'enable'
exec sp_fulltext_catalog 'XX','create'

exec sp_fulltext_table 'ArticleInfo','create','XX','pk_articleInfo_1'
exec sp_fulltext_column 'ArticleInfo','content','add'
exec sp_fulltext_column 'ArticleInfo','keyword','source','title','add'

exec sp_fulltext_table 'ArticleInfo','activate'exec sp_fulltext_table 'ArticleInfo','start_full'exec sp_fulltext_catalog 'XX','start_full'

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!