Create UPDATE script with current data

[hapax]

I have four rows in a table. I want to take the current values in those fields and create an UPDATE script that I can use to overwrite any future changes to these rows, to set them back to what they are today.

Here are the rows:

AssetId ClientId AssetNum ClientRef
----------- ----------- ---------- ----------------
62415 74 C56870 0269960
62416 74 C56871 3066163
62417 74 C56872 3066720
62418 74 C56873 6437729

AssetId is the PK.

There are actually a LOT more columns in this table, so I'm looking for a non-manual way to accomplish this.

 

[bborissov]

How you know which record(s) is/are TODAY records?
You must have some datetime filed, maybe?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[hapax]

I mean, I just want to update these four AssetId's.

The date doesn't matter. I just want to put the current values in an update script.

 

[hapax]

I just want to restore these four rows any the future with their current values (the values right now)

 

[bborissov]

SELECT * INTO SomeTableName FROM YourTable
WHERE AssetId BETWEEN 62415 AND 62418

Then when you need to get data back:

DELETE FROM YourTable WHERE AssetId BETWEEN 62415 AND 62418
INSERT INTO YourTable
SELECT * FROM SomeTableName

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[hapax]

Excellent. Thanks very much