How to cancel a delete command without using a transaction? if we cannot, then what is the difference between Truncate and delete?
You cannot roll back in this case, but when you use the Full recovery model , you can return your database until the time you issue the delete command.
ROLLBACK . , , COMMIT ROLLBACK. BEGIN TRANSACTION...COMMIT / ROLLBACK. , IMPLICIT_TRANSACTION.
ROLLBACK
COMMIT
BEGIN TRANSACTION...COMMIT / ROLLBACK
IMPLICIT_TRANSACTION
DELETE TRUNCATE ( ) , , . / .
TRUNCATE DELETE. TRUNCATE , DELETE . TRUNCATE , TRUNCATE , DELETE, .