sql全文索引的非聚合词库

--创建非聚合词库，有了的话 省去这步
CREATE FULLTEXT STOPLIST  StopListName;
--修改全文索引的默认非聚合词库为创建的词库
ALTER FULLTEXT INDEX ON Item SET STOPLIST StopListName; -- alter your table full text index with your new list
--test
select top 10 DomesticNumber from dbo.Item where  contains(DomesticNumber,'"*134*"');
select top 10 SellerName from dbo.Item where  contains(SellerName,'"*a*"');