Information générale
Forum:
Microsoft SQL Server
>>I have been adding records to my test SQL Server table all day. Now I noticed that after I add a record (from VFP app), I go to Enterprise Manager, open the table, and select to Return All Rows, I don't see the new records. It looks like that PK value got stock on 9384. Yet, I can retrieve the newly added record from my VFP app.
>>
>>What am I missing? Or do I need to refresh something in the Enterprise Manager to see the new records?
>>
>>Thank you.
>
>I just noticed that the newly added records are somewhere in the middle of the table, not at the end. Why? In what order does Enterprise Manage show the records when you open a table?
Without a cluster order, none order exists.
have you defined a cluster primary key ?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement