Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Database & SysAdmin
  3. Database
  4. SELECT Query

SELECT Query

Scheduled Pinned Locked Moved Database
databasequestionsql-serversysadmin
4 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Subramaniam s V
    wrote on last edited by
    #1

    Hi All, Can anyone answer me this question. Is there any restriction in the number of rows returned by a select command? Meaning that assume that I have over 1 million records in my table and I do a select from this table. Does my SQL Server 2000 restrict me by showing only first 1 lakh records or 2 lakh records etc etc. Does SQL has the capability of showing any number of rows returned by the SELECT command. Thanks

    P H S 3 Replies Last reply
    0
    • S Subramaniam s V

      Hi All, Can anyone answer me this question. Is there any restriction in the number of rows returned by a select command? Meaning that assume that I have over 1 million records in my table and I do a select from this table. Does my SQL Server 2000 restrict me by showing only first 1 lakh records or 2 lakh records etc etc. Does SQL has the capability of showing any number of rows returned by the SELECT command. Thanks

      P Offline
      P Offline
      pubududilena
      wrote on last edited by
      #2

      hi, you can use Top key word for that.. ex:- SELECT TOP 1000 PDateFrom FROM dbo.Period WHERE FareAutoNum=@FareAutoNum

      1 Reply Last reply
      0
      • S Subramaniam s V

        Hi All, Can anyone answer me this question. Is there any restriction in the number of rows returned by a select command? Meaning that assume that I have over 1 million records in my table and I do a select from this table. Does my SQL Server 2000 restrict me by showing only first 1 lakh records or 2 lakh records etc etc. Does SQL has the capability of showing any number of rows returned by the SELECT command. Thanks

        H Offline
        H Offline
        HimaBindu Vejella
        wrote on last edited by
        #3

        I think there is no restriction like that SQL has the capability of showing any number of rows returned by the SELECT command. U can check this link to get maximum capacity for sqlserver http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp[^] "Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshres http://himabinduvejella.blogspot.com

        1 Reply Last reply
        0
        • S Subramaniam s V

          Hi All, Can anyone answer me this question. Is there any restriction in the number of rows returned by a select command? Meaning that assume that I have over 1 million records in my table and I do a select from this table. Does my SQL Server 2000 restrict me by showing only first 1 lakh records or 2 lakh records etc etc. Does SQL has the capability of showing any number of rows returned by the SELECT command. Thanks

          S Offline
          S Offline
          S Douglas
          wrote on last edited by
          #4

          Subramaniam s.V. wrote:

          Does SQL has the capability of showing any number of rows returned by the SELECT command.

          Yes, the limitation is on the client, can the client display that many records. Beyond that why would you want to over whelm your use with 1 Million records? There is no way they could use that much information at once. It’s just better to break it down. Just my two cents.


          -- modified at 6:42 Wednesday 22nd March, 2006

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups