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.

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



© 2020 - ErnesTech - Privacy