Rollback to in sql

Rollback in sql

DELETE clause is from DML,
we can use ROLLBACK to recover the data.
• ROLLBACK —> discharges all pending changes to prev commit
• ROLLBACK TO name —> rolls back changes to savepoint

Commit in sql

• COMMIT —> making all pending changes permanent;
• SAVEPOINT name —> marks a save point
• ROLLBACK —> discharges all pending changes to prev commit
• ROLLBACK TO name —> rolls back changes to savepoint

Can we rollback in sql

es, since this DELETE clause is from DML,
we can use ROLLBACK to recover the data.

Rollback to in sql

• ROLLBACK TO name —> rolls back changes to savepoint

Similar codes

1 vote133 views1 answer
Tsql update datetime
SQL
0 vote157 views1 answer
Get cpu details sql
SQL
0 vote165 views1 answer
Sql select min row
SQL
0 vote172 views1 answer
How to subquey to do not load in live database in
SQL
2 votes152 views2 answers
How to rename column name in sql server using query
SQL
0 vote207 views1 answer
Generate sql from specific migration ef core
SQL
0 vote163 views2 answers
Mysql calcular idade
SQL
6 votes182 views2 answers
WHERE value IS sql
SQL
0 vote148 views1 answer
Logtash mysql cofiguration file
SQL
1 vote145 views3 answers
How to get date in sql
SQL