SQLSERVER 全文索引

-- 1、创建主键聚集索引
/****** Object:  Index [PK_customerID]    Script Date: 2018/8/10 16:36:21 ******/
ALTER TABLE [dbo].[userInfo] ADD  CONSTRAINT [PK_customerID] PRIMARY KEY CLUSTERED 
(
    [customerID] ASC
) ON [PRIMARY]
GO
-- 2、在“存储”-全文目录-新建全文
/****** Object:  FullTextCatalog [test]    Script Date: 2018/8/10 16:36:52 ******/
CREATE FULLTEXT CATALOG [test]WITH ACCENT_SENSITIVITY = ON
AS DEFAULT

GO

-- 3、创建全文索引
  CREATE FULLTEXT INDEX ON userInfo(customerName)
    KEY INDEX PK_customerID
    ON test
    GO

-- 4、开始查询

SELECT * FROM dbo.userInfo WHERE  CONTAINS(customerName,'"王" or "李"')

GO

参考网址:https://www.red-gate.com/simple-talk/sql/learn-sql-server/full-text-indexing-workbench/

posted @ 2018-08-10 16:40  xiaobudong  阅读(218)  评论(0编辑  收藏  举报