title: Does SQL have a list type that can be used in a WHERE ... IN clause?
body: <blockquote>
    <p><strong>Possible Duplicates:</strong><br>
    <a href="https://stackoverflow.com/questions/337704/parameterizing-a-sql-in-clause">Parameterizing a SQL IN clause?</a><br>
    <a href="https://stackoverflow.com/questions/537087/sql-server-sp-pass-parameter-for-in-array-list">SQL Server SP - Pass parameter for &ldquo;IN&rdquo; array list?</a>  </p>
  </blockquote>
  
  <p>I need to search for a haphazard set of integers on two different tables:</p>
  
  <pre><code>SELECT 
    col_1, col_2 
  FROM 
    LIKES_NUMBERS 
  WHERE 
    col_1 IN (1,2,3,5,7,1021,10041411)
  
  SELECT 
    col_one, col_two 
  FROM 
    LIKES_NAMES 
  WHERE 
    col_one IN (1,2,3,5,7,1021,10041411)
  </code></pre>
  
  <p>Is there a SQL list type that can be passed to IN so that I don't repeat myself?  E.G.</p>
  
  <pre><code>DECLARE @stuff UNOBTAINIUM(1,2,3,5,7,1021,10041411)
  -- ...
  WHERE col_1 IN (@stuff)
  -- ...
  WHERE col_one IN (@stuff)
  </code></pre>
  
  <p>Creating a temporary table comes to mind, but that seems brutal.</p>