If I am executing a set of queries using transaction, and one of the queries failed to insert/update/delete. What will happen? Will the remaining queries continue executing by default?
Asked
Active
Viewed 47 times
1 Answers
0
The answer is no. A rollback will be performed restoring the database to its original state before the transaction began: http://en.wikipedia.org/wiki/Rollback_%28data_management%29
mmvsbg
- 3,570
- 17
- 52
- 73
-
so if i need not to rollback, i should not use transactions? – Rashad.Z May 22 '15 at 11:56
-
Yes, if you don't want to restore the database then you should not use a transaction. – mmvsbg May 22 '15 at 11:57