Here's the scenario:

We have a script that basically will alter six tables in our dB. In order to keep the data intact, we have to, firstly, create six temp tables to store each of the affected tables data into. I think you can accomplish that with a select/like SQL statement, but I'm at a lose to what it is? Then, after the scripts execute, we'll copy the data, from the temp tables, back into the modified original tables. Finally, we'll drop the temp tables. What's the easiest way to code this?



¡Thanks, in advance, for everyone's help!