Ask Question

What is the difference between COMMIT and ROLLBACK process in Database ?

Last updated:9/16/2020 12:08:51 AM

MSSQL Server

SQL SQL Server 2008

1 Answers

MindStick Software Pvt Ltd

MindStick Software Pvt Ltd

19-Sep-2019

Each statement between BEGIN and COMMIT becomes persistent to the database when the COMMIT is executed. Each statement between BEGIN and ROLLBACK are reverted to the state when the ROLLBACK was executed.

report abuse

© Copyright © 2010 - 2021 MindStick Software Pvt. Ltd. All Rights Reserved