how to do undo a sql query

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

Hi every one,please see following queris and give me a solution.

"update emp_table set salary=500000"(Here i failed to give condition ,obviously all record will be updated)

Here i want to do undo any how becouse in this table there is more than Ten thousand records and for different employee there is different salary now accidently i fired the above query ,it puts me in a very big trubble.Please geive me some tricks as soon as possible .

Thanks a lot in advance

Posted 21-May-12 23:52pm

kunalkumarsingh

Updated 2-Nov-18 0:53am

v2

Add a Solution

Comments

Jim Jos 22-May-12 5:57am

You won't be able to undo as it is.. Have you got auditing feature enabled you ll have all the previous values there.. You need to update your table from the audit table.

kunalkumarsingh 22-May-12 8:46am

i dont have any idea about auditing feature will you please tell me how to do it from audit table?

Thanks in advance

ssd_coolguy 22-May-12 6:00am

if you have backup file then you can restore you table with values..

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2012-05-22T09:24:00

If you have already executed the statement without transaction, it's committed to the database. In that case, you can restore the database to a previous situation.

However, if you do that, you may loose modifications that are made after the backup. So One possibility is that you restore the backup to a whole new SQL server database (or even instance) and then using that database fetch all the original values from the table and put them in place in your actual table.

Mehdi Gholam · Answer 2 · 2012-05-22T00:00:00

Solution 1

You can use transactions for this :

SQL

begin tran
update emp_table set salary=500000

select * from emp_table

-- rollback tran
-- commit tran

You can do the testing with the above and if everything is ok use the commit tran else rollback tran

Posted 22-May-12 0:00am

Mehdi Gholam

uspatel · Answer 3 · 2012-05-22T00:07:00

Solution 2

If you have back up of previous data restore it.
You can roll back only transactions not query without transaction.

Posted 22-May-12 0:07am

uspatel

Abhinav S · Answer 4 · 2012-05-22T00:15:00

Solution 3

Its always best to run queries in a transaction so that you can rollback at anytime required.

Posted 22-May-12 0:15am

Abhinav S