Results 1 to 3 of 3

Thread: row num

  1. #1
    Join Date
    Dec 2001
    Location
    Canada
    Posts
    45

    Question Unanswered: row num

    can i have the row number in a select like ROWNUM in Oracle DB?

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


    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check this SQL TEAM link.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Dec 2001
    Location
    Canada
    Posts
    45

    Exclamation

    Originally posted by Satya
    Check this SQL TEAM 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?!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •