title: Oracle equivalent ROWNUM for SQL-Server 2005?
body: <p>In Oracle PL/SQL I was used to write:</p>
  
  <pre><code>SELECT * FROM MY_TABLE WHERE ROWNUM &lt;= 100;
  </code></pre>
  
  <p>in order to fetch only the first 100 records of the table named MY_TABLE.</p>
  
  <p>What could be the equivalent SELECT statement in SQL SERVER?</p>