well this is the first time in this forum so I'll be clear about my question and thanks in advance
I'll create a software in C#, this app takes a cvs file (about 73,000 lines). This files comes from another system,
also the cvs file can change, what's that means? the cvs file can change in one line ( the data ) or can have more new lines
or can have less lines, the cvs change every hour or half hour it depends!!!
I add those lines from the cvs file to a table in sqL,The first time is easy.. I just ADDNEW for each line in csv file. But,
the second time I cannot delete all table to import it again from the beginning because of these extra fields, or in other case
if a line in the cvs change, i can't drop all the data from the table.
so I need a method that can verify each record inside my SQL Table and CSV file automatically? Or I need to treat the records one by one?
If i compare every change it would be correct to use a cursor fot that?