Does SQL have a list type that can be used in a WHERE ... IN clause?

Answer 1

Yes, you can use a table variable for this. It's like a temp table, but locally scoped.

Answer 2

There's no list type. Temporary table should be fine or you can use a table variable.

Answer 3

This has been asked quite a number of times. SQL Server SP - Pass parameter for “IN” array list?

Also have a look at

• Arrays and Lists in SQL Server
• Arrays and Lists in SQL Server 2005 and Beyond

Answer 4

When using MS-SQL, I tend to use XML documents for this purpose, which can be easily passed from non-SQL clients (unlike temp tables, I believe) and queried by MS-SQL's T-SQL syntax.