sqlServer2005创建全文索引

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

导读：execute?? sp_fulltext_database?? 'enable' create fulltext catalog XX on filegroup [primary] as default create fulltext index on ArticleInfo([content],keyword,source,title) key index pk_ArticleInfo on XX --删除 DROP FULLTEXT INDEX ON Articl

execute?? sp_fulltext_database?? 'enable'

create fulltext catalog XX on filegroup [primary] as default

create fulltext index on ArticleInfo([content],keyword,source,title) key index pk_ArticleInfo on XX

--删除

DROP FULLTEXT INDEX ON ArticleInfo

DROP FULLTEXT CATALOG jinzhao

SELECT [resume]?FROM [PeopleBasic] ?where?(contains([resume],'大宝') or? contains([resume],'二宝')? )

（编辑：李大同）

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