Enhancement to "Warning on delete and update statements if no WHERE clause is specified"
This is a great idea, but I was surprised by the number of "false positives" I am getting (and yes, I can just mute the messages completely).
In my case I am doing a lot of updates/deletes with joins to temporary tables or table variables and that limits the update/delete scope.
Can you add to this feature so that messages will not be emitted if there is a join to a temporary table or table variable?
Thanks for your feedback on this feature! We’ve just released a new build of SQL Prompt (7.2.1) which won’t show these warnings when modifying temp tables with aliases.
We, too, use tons of tamp tables, thus the JOIN is the same to us as a WHERE. Please detect JOIN to eliminate the false-positives.