Why is this an issue?
DELETE statements should contain
WHERE clauses to keep the modification of records under control.
Otherwise unexpected data loss could result.
Noncompliant code example
DELETE FROM countries
UPDATE employee SET status = 'retired' FROM table1 AS employee
TRUNCATE TABLE countries
DELETE FROM countries WHERE CODE = @country_code
UPDATE employee SET status = 'retired' FROM table1 AS employee WHERE age > @maxAge
No issue is reported for statements made on temporary tables.