refactoringself.com
SQL Server Delete From vs. Truncate Table
There are some very important distinctions between these that I feel I need to explain. Delete From First and foremost delete is used for deleting a limited number of rows from a table. This is not…