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