Creating A Duplicate Row?

I have a table that I'll call 'places'. This is a table of places to visit and might look like this:

id (autoincrement), name, town, latitude, longitude, etc1, etc2, description

1, My barn, Toronto, 43.44, -79,443, y, n, "Country barn"

2, run down house, 46.4432, -79.4322, y, y, "this is an old house that seems to have been forgotten"

4, parking lot, 45.4322, -80,4333, n, n, "An vacant parking lot, overrun with grass"

I'm trying to implement a 'revert' feature sort of like Wikipedia's (Undo) where if someone vandalizes an entry in the table I can revert it. People can edit the description and latitude, longitude. The ID and name generally stay the same.

I'd like to copy the entire row (about 20 columns in a single row, I didn't list them all) to a temporary table or new row. I think using a new row in the same table might not be a good idea because it would cause the autoincrement ID to increase and I plan to delete the temp row when done with it anyway. Don't want too many gaps in the ID field.

Basically I want to have a script (I'll code it myself) that I can approve or disprove the changes to the row. If the changes are invalid (someone has put bad info in, erased the GPS fields, etc) then I just delete the temporary row and nothing changes.

If it's a valid change then I'd have to do something like an UPDATE to update the original row with the info from the temp table.

eg. OLD data from 'places'

2, run down house, 46.4432, -79.4322, y, y, "this is an old house that seems to have been forgotten"

NEW data put into 'places' via UPDATE command:

2, run down house, 46.4342, -79.4222, y, y, "this is an old house that seems to have been forgotten. I have fixed the GPS data that was inauurate."

So it's a matter of updating the old row and deleting the temp table afterwards. I'm not familiar with stored functions or routines in SQL. I use Server Management Studio but only for running queries and viewing the columns - I don't know how to store any routines in the database.

All my code is done simply by sending strings to SQL from Active Server:

sqlst = "insert into table <whatever>"
Set objRs = objCmd.Execute(sqlst)

So if it's possible to accomplish this just through executing a few queries, great. Otherwise I might have to learn how to do a stored routine in SQL.