--清空内存中所有缓冲
CHECKPOINT
DBCC DROPCLEANBUFFERS
----创建表
--CREATE TABLE TextInfo(
-- Id INT IDENTITY(1,1),
-- Email NVARCHAR(256),
-- Quote NVARCHAR(1024)
--)
----聚集索引
--CREATE UNIQUE CLUSTERED INDEX TextInfoIX ON TextInfo (Id)
----向表中添加数据
--INSERT INTO TextInfo(Email,Quote)
--VALUES(N'joe@gmail.com',N'The less you talk,the more you''re listened to.')
--INSERT INTO TextInfo(Email,Quote)
--VALUES(N'bob@yahoo.com',N'Nature cannot be fooled')
--INSERT INTO TextInfo(Email,Quote)
--VALUES(N'mary@gmail.com',N'The truth is not for all men.')
--INSERT INTO TextInfo(Email,Quote)
--VALUES(N'alice@12titans.net',N'Delay is preferable to error.')
--常规查询
--SELECT * FROM TextInfo t WHERE T.Email LIKE '%12titans%'
--创建全部索引目录
CREATE FULLTEXT CATALOG [SeachCatalog] AS DEFAULT
--给表创建全文索引
CREATE FULLTEXT INDEX
ON TextInfo(Email,Quote)
KEY INDEX TextInfoIX
--查询确定索引何时构建完成，0：构建完成1：构建中
SELECT FULLTEXTCATALOGPROPERTY('SeachCatalog','PopulateStatus')
--全文索引查询
SELECT * FROM TextInfo WHERE CONTAINS(email,N'12titans')
