RowNum question

[Kutadgu Arslan]

Hi everyone,

My question is,
Does SQL Server 2k's Trannsact SQL has the ability of Oracle's
rowNum.
I know that this is not a query process but may be T-SQL has this.

For example; Could i go to the 10th,3th or 50th (etc.) row of my query result?

Thank you very much for your answers

[Rob Vieira]

No - there really isn't a direct equivalent.

Common hacks around this range from using an appropriate cursor to selecting
things into a working table that has an autonumber field.

When you think about it, the rownum business is a violation of the rules of
relational data. That said, it's actually pretty darn handy in some cases -
maybe they'll add it in Yukon.

--
Rob Vieira
Visit www.ProfessionalSQL.com Today. It's new and improved!

"Kutadgu Arslan" <kutadgua@coretech.com.tr> wrote in message
news:3a6d326b$1@news.devx.com...
>
> Hi everyone,
>
> My question is,
> Does SQL Server 2k's Trannsact SQL has the ability of Oracle's
> rowNum.
> I know that this is not a query process but may be T-SQL has this.
>
> For example; Could i go to the 10th,3th or 50th (etc.) row of my query
result?
>
> Thank you very much for your answers
>
>
>
>
>