row num

can i have the row number in a select like ROWNUM in Oracle DB?
:confused:
I want to to

create procedure sp_table1_sel( @.startRow bigint, @.endRow bintint)
AS
SELECT *
FROM table1
WHER rownum < @.startRow
AND rownum > @.endRow

How can I do that?!

ThanksCheck this SQL TEAM (http://www.sqlteam.com/item.asp?ItemID=1491) link.|||Originally posted by Satya
Check this SQL TEAM (http://www.sqlteam.com/item.asp?ItemID=1491) link.

OK I read something like this in the MSDN mag (may 2003) but if a have 60 000 rows in the table? The query take 30 sec...

something better?!