1) Delete has where condition. Truncate does not have where condition. 2) Delete records based on where condition but truncate delete all records from table. 3) Delete does not reset the identity of table. Truncate reset the identity of table. 4) Truncate is faster then delete.

Answer:

Both Truncate and Delete are used to delete data from the tables.  Below are some important differences.

        TRUNCATE is a DDL (data definition language) statment whereas DELETE is a DML (data manipulation language) statement.
 

• In DELETE command we can use where condition in TRUNCATE you cannot.
   
• TRUNCATED data cannot be rolled back while delete can be.
   
• When there are triggers on table and when you fire truncate trigger do not fire . When you fire delete command triggers are executed.
   
• TRUNCATE resets the identity counter value where DELETE does not.
   
• Delete and Truncate both are logged operation. Delete operation is logged on row basis while TRNCATE logs at page level.
   
• TRUNCATE is faster than DELETE.
  
   
  Regards,
  
  View my 21 important .NET interview questions and answers