Thread: Undo A Delete

I dont supose there is a way to undo, or restore, a "delete from table
where...."?

Any thoughts appreciated.

Darren


--
Darren Greer
System Administrator -
Applications Development Manager
Websight Solutions Inc.
Phone: (414) 790-9327 | Fax: (414) 790-5952

> I dont supose there is a way to undo, or restore, a "delete from table
> where...."?

Use transactions (BEGIN, COMMIT, ROLLBACK, etc.)  If you delete data 
inside of a transaction and then rollback, your data will be restored.  
At least I think that's how it's supposed to work!

Brett W. McCoy                                                   http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
The wind doth taste so bitter sweet,Like Jaspar wine and sugar,
It must have blown through someone's feet,Like those of Caspar Weinberger.    -- P. Opus

id really like to find out info on courses on sql and database
admin/architecture
both in univ/college situation or study at home online etc

i live in vancouver bc canada


thanks!


************

id really like to find out info on courses on sql and database
admin/architecture
both in univ/college situation or study at home online etc

i live in vancouver bc canada


thanks!


************