Skip to main content
1 of 2
Vinoth _S
  • 857
  • 8
  • 15
  • 24

How to rollback after wrong update statement in sql server 2008R2?

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

Vinoth _S
  • 857
  • 8
  • 15
  • 24