Re: it's so easy
BEGIN TRAN
START TRAN
SET TRAN
IMPLICIT TRAN
(choose as appropriate)
Then DELETE FROM WHATEVER WHERE THING = OTHERTHING
If oh shit 1234434554453 rows deleted (I was expecting 1)
then ROLLBACK
otherwise if you are happy
COMMIT