SQL Prompt execution warnings

In this tip Bob Pusateri explains how SQL Prompt execution warnings can prevent you from making a costly change to your database.

Transcript:
Hi I'm Bob Pusateri and I've got a SQL Prompt tip for a feature I think is incredibly helpful - execution warnings. Let's say you're in a stressful situation and need to update some records in your database. Right as you're executing your query you realize you forgot to include a where clause and are updating the entire table instead of only a few rows just like I will do here.

Fortunately SQL Prompt is silently watching your queries and will pop up with an execution warning telling you your update statement doesn't include a where clause. You can then decide to not execute the query so you can make changes or to go ahead and run it anyway if that was what you had intended. You also have the option of disabling these alerts.

Execution warnings work for both update and delete statements.

Hopefully you'll find execution warnings to be as useful as I have. Be sure to get the latest update to SQL Prompt and give it a try.