Please Login to Continue

Free Software Development Articles.Email List

Advertise Here

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.
Technology published
Buy Me Coffee

Was this page helpful?

Yes Yes! this solution to the problem was helpful. No No! this solution to the problem was not helpful..

© 2020 - ErnesTech - Privacy