DF192: An UPDATE statement is used without WHERE clause.

Last modified: December 25, 2024

The topic describes the DF192 T-SQL code analysis rule.

Category

BEST PRACTICE

Message

An UPDATE statement is used without WHERE clause.

Description

The absence of a WHERE clause in an UPDATE statement can potentially result in data loss.

Noncompliant code example

UPDATE dbo.Personnel
SET Salary = 0;

Compliant solution

UPDATE dbo.Personnel
SET Salary = 0
WHERE PersonnelNo = 12;