RowNum question


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: RowNum question

  1. #1
    Kutadgu Arslan Guest

    RowNum question


    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





    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: RowNum question

    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
    >
    >
    >
    >
    >



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center