Hi all,

please inform there is rownum field available in sql server 2000.
how can select / see the rownum field ?

as in oracle rownum, we " select rownum from tablename"
it display all rownum.

how can we past our query result from the sql server 2000 database
any suggestion that sql server query become paster ?
display result quickly.

regards.

Mateen Martin
[email protected]

Hi Mateen,

A 0.0005 second query in Google (http://www.google.com/search?hl=en&l...+Server+oracle) brings to you this article:

http://vyaskn.tripod.com/oracle_sql_...quivalents.htm

which in turn brings you to this article:

http://support.microsoft.com/default...;EN-US;q186133

which answers your question.

Use Google wisely. It will often give you the correct answer and faster than posting a question to this list......