I am using SQL 2005 Express.
I have a table with an auto increment field named rec_id. This table has 5 'funny' records, rec_id 33941 to 33945. Fyi, the table has no problem adding records and the rec_id now has gone beyond that 5 records, 34000+. We only discovered these 5 records today.
If I do a "Select rec_id from masterreceipt", that set of 5 records will always remain at the bottom 5, even if I added "order by rec_id" to the command. The result will look something like this.
But if I further add "desc" to the same command, that set of 5 records will not appear at all.
And also, that 5 records cannot be 'inner join' by other tables. It will not return the rows.
I am pretty sure that set of records has never been thru an update or a delete command. I've checked the content as well, nothing out of the ordinary.
Can anybody please tell me what is going on?