Problem with Microsoft SQL Server 2005 database, unlimited load of data

Discussion in 'Databases' started by WiroWaas, Jul 28, 2010.

  1. #1
    Hi All, I have a problem with a table on my Microsoft SQL Server 2005 database. The data on a table named patient_diagnose looped itself from 1 to 4000 to unlimited entries. So when I select * from patient_diagnose, the result is unlimited load of data. Is there anyway to fix it?
     
    WiroWaas, Jul 28, 2010 IP
  2. Martin K

    Martin K Active Member

    Messages:
    262
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #2
    Did you close the database ?
    where $connect is
     
    Martin K, Jul 29, 2010 IP
  3. skytide

    skytide Peon

    Messages:
    25
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    What do you mean by "unlimited data"? There should be a certain number of rows in that table. You can do

    SELECT COUNT(*) FROM patient_diagnose

    to see how many rows there are. If you only want to select a few rows, use the TOP command. Like:

    SELECT TOP 100 * FROM patient_diagnose
     
    skytide, Jul 30, 2010 IP
  4. WiroWaas

    WiroWaas Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    No, I didn't


    I mean the result load never end with data replication.
     
    WiroWaas, Jul 31, 2010 IP
  5. Martin K

    Martin K Active Member

    Messages:
    262
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #5
    Then do it :)
     
    Martin K, Aug 7, 2010 IP