SQL Server查询的最大大小？IN子句？有更好的方法吗？

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

SELECT t1.column_name(s)
FROM table_name t1
JOIN (SELECT value1 as val UNION ALL SELECT value2 UNION ALL SELECT value3) t2
ON t1.column_name = t2.val;

CREATE TABLE #temp (column_name int);

INSERT INTO #temp (column_name)
VALUES (value1), (value2), (value3);

SELECT t1.column_name(s)
FROM table_name t1
JOIN #temp t2
ON t1.column_name = t2.column_name;

DROP TABLE #temp;

CREATE TYPE dbo.IntList AS TABLE (Value INT);

CREATE PROCEDURE usp_GetData
    @values IntList READONLY
AS
BEGIN
    SELECT t1.column_name(s)
    FROM table_name t1
    JOIN @values t2
    ON t1.column_name = t2.Value;
END;