问对多个值更快地等效Server子句

EN

SELECT TheColumn from TheTable T
INNER JOIN (SELECT * from (VALUES(1),(2),(3),(4)) as V1(value)) V
ON T.TheColumn = V.value

string joinedIds = string.Join("),(", new List<int> {1, 2, 9});

string command =
    $"SELECT * from Employee AS E INNER JOIN (SELECT * from (VALUES( {joinedIds} )) as TV(value)) V ON E.Id = V.value";

List<Employee> employers = db.Select<Employee>(command);

CREATE TABLE #ParamTempTable (Id BIGINT NOT NULL PRIMARY KEY);

INSERT INTO #ParamTempTable (Id) VALUES ((1), (2), (3));

SELECT *
FROM MyTable
WHERE Id IN (SELECT * FROM #ParamTempTable);

DROP TABLE #ParamTempTable;