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 am wrongly update my record Lastname,City column now i want rollback old Table Record in Sql Server 2008 R2.

Thanks

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.