It's My World - Anisur Rahman

  • Truncate cannot be rolled back while Delete can be.
  • Truncate keeps the lock on table while Delete keeps the lock on each row.
  • Truncate resets the counter of the Identity column while Delete doesn’t do so.
  • Trigger is not fired in Truncate while it happens in Delete.

View original post

Advertisements