Use a table variable to hold a list of values

July 4, 2023 · 1 min · Brandon Pugh | Suggest Changes

You can store a “list” of values in sql with a table variable.

DECLARE @listOfIDs TABLE(id INT);
INSERT INTO @listOfIDs
SELECT id
FROM Transactions
WHERE USER='bob';