How to undo a query in sql
- how to undo changes in sql server
- how to roll back changes in sql server
- can you undo a sql update
- how to undo changes in sql table
How to undo an insert in sql.
How to undo an UPDATE or DELETE in SQL Server
When ‘that’ Update statement wipes your database
No matter how careful or experienced you are at SQL Server development, there will inevitably be times when you run a query that you really wish you had not run.
How to rollback update query in sql server management studio
I was working on a project recently for a client and hacking around with my local development environment to try and fast track a piece of functionality. The hack involved updating a series of rows in a 1,500,000 row table and I was executing a series of UPDATEs in SQL Management studio because I didn’t want to waste time writing an admin script to do it.
All was going well until I accidentally highlighted half of the UPDATE (without the WHERE clause of course) and one brief F5 press later I was very surprised to read that I had “Successfully updated 1.5 million rows”.
It was only suppose to be 2.
Uh oh.
It might have been a development environment but I had a couple of months of work invested into this database and copying back from the live environment would not have helped. Like a
- how to undo in sql server
- undo changes in sql