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?
2
votes
Jim
shared this idea
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.
-
SAinCA55
commented
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.