recover deleted data

I want to learn that if my query deleted all data in the table by mistake, is it possible recovery and how?

Hi Sinem,

If you did taht in a transaction:

BEGIN TRANSACTION
<DELETQuery>
--YOu Can do a ROLLBACK Here

If not or you commited it′, you need a backup to restore. If you have a Full backup and kept the transaction log backups you can do a Point in time recovery to the second where you deleted it. No backup, no data.

HTH, Jens Suessmeyer.