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
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