Updating a table,what's the best approach to fix it
Posted on 2013-01-16
I have 2 tbls. A & B
In table B, I have the primary key pID and a column for TSN. Both are populated.
In table A, I have some rows with no pID or TSN values. Also I have some rows with pID but no TSN.
For table A,I think I will not be able to do anything with the ones with no pID or TSN because there will not be a link,(if there is a way,let me know) but I will be able to get the pID for those with TSN.
In table A, I added a column to tag it as "Yes" if an update occurs.
What is the best approach to update it?
Is it better to do it in VB.net by looping to each record and update one row at a time or do it straight to the backend and do a mass update thru an Update statement?