This question already has an answer here:
- How do I get back some deleted records? 3 answers
select * from aa update aa set City='chennai',LastName='vinoth'; ID FirstName LastName City 29 Abcrdrr vinoth chennai 1 John vinoth chennai 2 Joe vinoth chennai 35 raja vinoth chennai 38 Johsdfgn vinoth chennai
I have wrongly updated
Lastname, City columns in all the rows. Now I want to rollback to the old table rows.
Using SQL-Server 2008R2.