Oracle equivalent ROWNUM for SQL-Server 2005?

Question

In Oracle PL/SQL I was used to write:

SELECT * FROM MY_TABLE WHERE ROWNUM <= 100;

in order to fetch only the first 100 records of the table named MY_TABLE.

What could be the equivalent SELECT statement in SQL SERVER?

Answer 1

In SQL-Server You can Use TOP to select the no. of rows.

SELECT TOP 100 * FROM MY_TABLE

Answer 2

select top 100 * from tbl

column name is required or use *