16 How to rollback a query in SQL

How to rollback a query in SQL

How to rollback a query in SQL
Can you reverse a SQL query?
How do I ROLLBACK an executed query in SQL Server?
What is ROLLBACK in SQL with example?
How do I ROLLBACK a MySQL query?
Can you undo SQL query?

Happy Learning.

[fantooshh]

really helpful brother ahmed, jazakallah khair... kindly share these types of tips in the future also as it will help new dba's in many ways.

[mahmoudhassanine]

thank you and very helpful
but if i didn't start the transaction
how can i rollback ?

[abdullahquhtani]

Thank you so much. Highly appreciated.

[indrajitchakraborty]

How do I rollback a single query among 10 queries inside a single transaction

[heliophilekota]

Sir in case we did not back up in that case how to undo

[farookmohammad]

hello sir, could you please tell which mic you are using and how did you make such clear audio for video . this will be very helpful to me, thank you so much .

[lovishgoyal]

is the transaction stage saved so that we can roleback later? What I mean, lets suppose run the wrong script on production and after couplr of hours or days, can we roleback particular transaction from transaction name or stage or any reference of that transaction?

[bhanukalia]

what if we delete rows without using begin tran, then can we recover records?

[guillaumezeler]

thank you man !! you helped me a lot :D

[makrno]

Nice bro can you do it in english next time pls

[davidlp]

Update statements scare the shit out of me. Do a select first lol. Colleague almost fucked the production database at work by missing the where clause. 😂 Didn't start a transaction either.