Sql Row Back the Transaction When Possible

When working in SQL Server Management, it is important to make sure that you back-up all your database, to start with. Then whenever you need to update or write a Store Procedure to Update a Field in the Table, make sure that you use "Begin tran" which stand for "Begin Transaction". If you start your query with "Begin Tran" in future you might have a chance to roll-back the changes. Let's say, you updated the field in the table and then you want to undo the changes, type "Rollback;" and voila, you have the changes rolled back.
Edit this Article
Was this page helpful?
Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful.. Leave ErnesTech Feedback.Feedback
If you log in, you will be notified when someone leaves a comment.

Other users would like to know if this solution helped you.

Your Session is Ending
Login to Continue

© 2021 - ErnesTech - Privacy