一种方法是使用values语句构造查询，并使用join和group by：

SELECT p.ProductId
FROM Products p JOIN
     (VALUES ('AVJ'), ('LNK'), ('GEH')) vals(v)
     ON p.description LIKE '%' + vals.v + '%'
GROUP BY p.ProductId
HAVING COUNT(*) = (SELECDT COUNT(*) FROM vals);

然后，您可以使用split()或其他方法将其泛化，以将字符串转换为表：

WITH vals(v) as (
      SELECT *
      FROM dbo.split(@vals, ',')
     )
    SELECT p.ProductId
    FROM Products p JOIN
         vals
         ON p.description LIKE '%' + vals.v + '%'
    GROUP BY p.ProductId
    HAVING COUNT(*) = (SELECT COUNT(*) FROM vals);

您可以通过Google SQL Server split获得split()函数的实现。

将Excel文件加载到表中（SSIS或使用OPENROWSET）。

WITH conditionCountCTE (
  -- Get the count of conditions
  SELECT COUNT(*) conditionCount FROM excelTable
)
, ProductIDCTE (
  -- Find out how many conditions match
  SELECT ProductID
  FROM Product
  INNER JOIN excelTable
    ON Product.description LIKE N'%' + excelTable.condition + N'%'
  GROUP BY ProductID
  -- Get only those records where the condition count equals to match count
  HAVING COUNT(*) = conditionCountCTE.conditionCount
)
-- Get the data
SELECT
 *
FROM
 Products P
WHERE EXISTS (
  SELECT * FROM ProductIDCTE PCTE WHERE PCTE.ProductID = P.ProductID
)