USE Northwind
GO
SELECT CategoryName, Description
FROM Categories
WHERE CONTAINS(Description, 'ISABOUT (spread weight (.8),
sauces weight (.4), relishes weight (.2) )' )
GO
上面的结果通过
select I_ID,I_CategoryID,I_MerchandiseID,s_merchandisename from cs
where contains(s_merchandisename,'"尼康" and "D70" and "尼康D70" ')
语句查询结果,为什么存在"镜头 尼康 AF 70-300mm F-4-5.6G" 这样的记录
怎样剔除掉.