How to use roll back query in SQL server 2008

Questions by plresponse

Showing Answers 1 - 1 of 1 Answers

suji

  • Nov 6th, 2011
 


Here is how you can use rollback in any of the SQL Server versions. works in both SQL Server 2000 and later versions.

Code
  1.  



SQL Server 2005 or later 

Code
  1.  



Here is the same with COMMIT transcation

Code
  1.  

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions