Home > IT Answers > SQL Server > Data updation issues in a SQL Server table
SQL Server Ask the Experts
2,585 pts.
 Data updation issues in a SQL Server table
SQL Server Data Validation, SQL Server databases, SQL Server tables
I have accidentally updated all data in a SQL Server table according to one data source, and now all my data is a copy of that data. How can I make a command to allow all data in that table to search for other data and update, according to another reference table?

Software/Hardware used:
ASKED: February 2, 2009  6:08 PM
UPDATED: February 2, 2009  8:20 PM
RELATED QUESTIONS
Answer Wiki:
If you have a primary key in your table that is messed up that corresponds to a value in the other table then yes you can. You may want to look a Lumigents Log Explorer and simply roll back the incorrect statement (will only work if your database is in full recovery mode).
Last Wiki Answer Submitted:  February 2, 2009  8:20 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _