--
1:打开全文索引功能
-- execute sp_fulltext_database 'enable'
-- 2:创建全文索引Search
-- execute sp_fulltext_catalog 'Search','Create'
-- 3:命名SearchID成唯一的、不可为空的、单列的索引。
-- create UNIQUE index SearchID on Question(ID)
-- 4:在Question上创建全文索引
-- execute sp_fulltext_table Question,'create','Search','SearchID'
-- 5:设置全文索引列名Title
-- execute sp_fulltext_column 'Question','Title','add'
-- 6:设置全文索引列名Content
-- execute sp_fulltext_column 'Question','Content','add'
-- 7:建立全文索引
-- execute sp_fulltext_table 'Question','activate'
-- 8:填充全文索引目录
-- execute sp_fulltext_catalog 'Search','start_full'
-- 9:检查全文目录填充情况
-- WHILE FulltextCatalogProperty('Search','PopulateStatus')<>0
-- BEGIN
-- 如果全文目录正处于填充状态,则等待30秒后再检测一次
-- WAITFOR DELAY '0:0:30'
-- END
-- 10:用Contains查询Title列或Content列中包含有a或s字符串数据
-- SELECT Title,Content FROM Question where Contains(Title,'调用') or contains(Content,'调用')
-- 11:用Freetext查询Title列或Content列中包含有a或s字符串数据
-- select Title,Content from Question where freetext(*,'asd')
-- execute sp_fulltext_database 'enable'
-- 2:创建全文索引Search
-- execute sp_fulltext_catalog 'Search','Create'
-- 3:命名SearchID成唯一的、不可为空的、单列的索引。
-- create UNIQUE index SearchID on Question(ID)
-- 4:在Question上创建全文索引
-- execute sp_fulltext_table Question,'create','Search','SearchID'
-- 5:设置全文索引列名Title
-- execute sp_fulltext_column 'Question','Title','add'
-- 6:设置全文索引列名Content
-- execute sp_fulltext_column 'Question','Content','add'
-- 7:建立全文索引
-- execute sp_fulltext_table 'Question','activate'
-- 8:填充全文索引目录
-- execute sp_fulltext_catalog 'Search','start_full'
-- 9:检查全文目录填充情况
-- WHILE FulltextCatalogProperty('Search','PopulateStatus')<>0
-- BEGIN
-- 如果全文目录正处于填充状态,则等待30秒后再检测一次
-- WAITFOR DELAY '0:0:30'
-- END
-- 10:用Contains查询Title列或Content列中包含有a或s字符串数据
-- SELECT Title,Content FROM Question where Contains(Title,'调用') or contains(Content,'调用')
-- 11:用Freetext查询Title列或Content列中包含有a或s字符串数据
-- select Title,Content from Question where freetext(*,'asd')