You very rarely want to delete all the rows in a table (and when you do: you might consider truncate). Maybe be more specific?
Bad:
delete
from Accounts
Good:
delete
from Accounts
where Id = @id
You very rarely want to delete all the rows in a table (and when you do: you might consider truncate). Maybe be more specific?
Bad:
delete
from Accounts
Good:
delete
from Accounts
where Id = @id