9 ms·
I've always written my sensitive delete queries like this: select * -- delete x from Table x where x.whatever = 1 That way by default it's just a sele
by Johngibb 15y ago
I've always written my sensitive delete queries like this:
select *
-- delete x
from Table x
where x.whatever = 1
That way by default it's just a select, and then AFTER you verify the result set you can highlight from the delete on and then run the query (as long as you're in a shell that will run only the highlighted part. I was working in SMS.) This was a common idiom where I worked.