在SQL Server 全文索引中删除干扰词

CREATE TABLE dbo.Stoplist 
(
    Stopword NVARCHAR(64) NOT NULL PRIMARY KEY
);

INSERT INTO dbo.Stoplist (Stopword) VALUES (N'干扰词汇1');
INSERT INTO dbo.Stoplist (Stopword) VALUES (N'干扰词汇2');
INSERT INTO dbo.Stoplist (Stopword) VALUES (N'干扰词汇3');

ALTER FULLTEXT INDEX ON dbo.TableName SET STOPLIST OFF;
ALTER FULLTEXT INDEX ON dbo.TableName SET STOPLIST ON;

ALTER FULLTEXT INDEX ON dbo.TableName START FULL POPULATION;