Can you tell me the difference between DELETE & TRUNCATE commands?

Hi Praveen,

TRUNCATE is also rollback the data.But difference is TRUNCATE can't mantian the log.

TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server. 
DELETE is a DML command and can be rolled back. 
 
Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster.

More info at :

http://www.faqfarm.com/Q/How_do_you_differentiate_between_truncate_and_delete

http://www.geekinterview.com/question_details/425