Code Analysis


UPDATE statement without WHERE or INNER JOIN clause

The UPDATE statement has neither a WHERE nor an INNER JOIN clause, and it will update every row in the table.

It is very easy to update an entire table when you mean to update just one or more rows. Update statements should also be in a transaction so you can check the result before committing.

Available in

SQL Prompt

SQL Code Guard

Didn't find what you were looking for?