Information générale
Catégorie:
Bases de données
>>Hi,
>>I importing every day massive recordset from different manufacturers with updated pricelist and artikel set. Before import it, I delete old one, and then INSERT BULK another pricelist.
>>Don't exact understand what you mean about pk_id, but pk_id field exist, its guid string and updatable
>
>My question is - in that table do you have 1 record per manufacturer or many records per manufacturer?
>
>Also, did you try MERGE statement (assuming you're using SQL 2008) to update records instead of deleting and insert non-matched delete not-matched by target
>
>?
No, I did not try, there in this thread I read solution about mark records as deleted by set additional boolean field to true, and then
update them instead delete. but then I can't use INSERT BULK for fast import.. or I have not enough exp. for this.
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