Hi,
I am converting more and more customers from VFP to the SQL Server. I have a procedure that deletes a bunch of records in a table and then refills them with new values. The number of records is not huge; maybe 2000-3000 max.
My old VFP code was designed to recycle these records. That is, instead of deleting, the code would set a key field value to "$-DEL-$" (to avoid conflict) and then, during the process of refilling them, SEEK and update.
I want to refactor this code and do away with recycling. Does SQL Server recycle records on its own? Or do you think it is still worth recycling the records in the SQL Server table?
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
