2 ms·
BEGIN TRAN DELETE FROM ... SELECT FROM ... ROLLBACK TRAN -- things look bad, itchy finger, etc COMMIT TRAN -- things look good, skip previous line That
by DenisM 15y ago
BEGIN TRAN
DELETE FROM ...
SELECT FROM ...
ROLLBACK TRAN -- things look bad, itchy finger, etc
COMMIT TRAN -- things look good, skip previous line
That, and I have 15-minute backups for all databases I care about.