使用CONTAINS来找到某个单词和另外一个互相接近的行。语法如下:
{<simple_term> | <prefix_term>}
{NERA | ~}
{<simple_term> | <prefix_term>}
USE AdventureWorks
GO
SELECT DocumentSummary
FROM Production.Document
WHERE CONTAINS (DocumentSummary,'oil NEAR grease')
这个例子寻找grease这个词和oil这个词相邻的所有文本。这个示例根据两个单词的相邻进行搜索,你还可以测试多个单词的相邻,例如:
USE AdventureWorks
GO
SELECT DocumentSummary
FROM Production.Document
WHERE CONTAINS (DocumentSummary,'oil NEAR grease AND frequency')