Home > Articles > Details

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.
If you log in, you will be notified when someone leaves a comment.

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


© 2022 - ErnesTech - Privacy