title: Is there an easier way to fill a column in SQL Server 2008?
body: <p>I'm creating a temp table and I want to fill the column from 0-9999 using T-SQL.</p>
  
  <pre><code>create table #tmp5 (userID int)
  </code></pre>
  
  <p>Is there an easier way to fill a column up instead of using a loop?</p>