Skip to the content.

You very rarely want to delete all the rows in a table. Maybe be more specific?

Bad:

update Accounts
set Balance = 0

Good:

update Accounts
set Balance = 0
where Id = @id