title: autonumber in select statement in SQL Server
body: <p>I would like to create a select query statement with autonumber.. like..</p>
  
  <pre><code>select * from tbl1
  </code></pre>
  
  <p>will give me everything from table.</p>
  
  <p>The result I'd like to get is..</p>
  
  <pre><code>1         data
  2         data
  3         data
  </code></pre>
  
  <p>So how can I do to get that number..??</p>
  
  <p>like..</p>
  
  <pre><code>select (for autonumber), * from tbl1
  </code></pre>
  
  <p>the data in my table will repeated (no unique data)</p>