sql real interview question and answer
SQL Interview questions and answers what is the difference between delete and truncate? we can rollback delete statement but can't rollback truncate. delete does not reset identity of table , truncate reset identity value delete lock row for deletion and truncate lock entire table. delete is data manipulation , truncate is data definition language we can use where with delete but can't use with truncate