Regarding rollback query

Question

How to rollback update statement in sql server. Explain with example

Nilesh Patil · Answer

Hi The short is NO. A non-committed transaction can be reverted by issuing the command ROLLBACK But if you are running in auto-commit mode there is nothing you can do....

Ravi Kiran Chanduri · Answer

You can rollback the updated on a table when process is in transaction We genrally use transactions when we do insert or update operations through stored procedure(doesn't mean that cann't do in plan script) giving you an example of transaction in SQl we have a requirement to update the employee table based on the ID  if 2 or more rows are updated  it should be roll back and return a message SQL code create table #employee (ID int  Name Varchar (100) Age int ) insert into #employee values (1 'ravi' 30) (1 'kiran' 28) (2 'Raju' 30) select * from #employee -- actual trasaction process starts from here BEGIN TRAN t1 Update #employee set name = 'Ravikiran' where ID=2 IF(@@rowcount>1) ROllBACK TRAN t1 ELSE Commit TRAN t1