Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>Hi Claude
>>>>1. Why does table Tx have fewer records then table x?
>>>
>>>The original table has deleted records. So, they are not missing. You can use count function to see how many active records are in the original table.
>>>I bet you will have the very same number with select statement
>>>
>>>>2. What is the best way to find what records are missing?
>>>
>>>DO you need deleted records too?
>>
>>I think so. It would be the safest way to go.
>
>Then I would COPY FILE instead of using SELECT.
I used select because the file is on a shared server and is being used. Can I sill use COPY FILE?
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