Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2000
Naomi:
I'd rather not go through all the records 1-by-1 just to delete records.
At this time I'm only concerned with 1 table. This table has about 50,000 records. Would it be wise to just delete all the records in this table and just IMPORT all the updated records from the updated table? How would one delete all the records in a table?
Mal
>>Hi:
>>
>>I have 2 locations each with a SQL Server machine. One machine is alwasy updated. I use EXPORT from the updated machine then IMPORT into the other machin to keep the machines the same. This has been working out, but recently I've been getting duplicate recrods. How do I implement an IMPORT and elimnate/ignore dulicate records. Is there a way to tell SQL Server's Import to ignore records already in the table?
>>
>>TIA
>>
>>Mal
>
>Mal,
>
>I'm not sure it's the right answer, but you can always add a check after your process is done and eiliminate duplicates.
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