how to undo the last command in SQL Query analyzer?
Posted on 2004-10-03
hello guys, I'm desperately need your help immediately.
i have issued a statement on my sql query analyzer that change all other record on a table. how do i undo this statement?
instead of committing this statement
update table1 set column1 = 'a' where column2 = '1' and column3 = '2' and column1 <> 'z'
i typed the wrong statement
update table1 set column1 = 'a' where column1 <> 'z'
which changes all other record on table 1 rather than records with column1 = 'z'
here's the question. How do i undo the statement like we do to undo the last action in msword, msexcel and other app programs.
sorry about this question, all i got is 190 points. Please help me right now. I've been balancing this records to reconcile the subsidiary ledgers.