What is difference between TRUNCATE and DELETE statement
Answer Posted / hari
Delete - is logged operation,so deletion of each row get
logged into the transcation log.
Truncate - won't logged
Delete - use where condition
Truncate - Can't use where condition
delete - fire the trigger
Trunacte - can't fire the triggger
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are diverse clauses that form a part of sql?
What are the different types of stored procedures?
What is create statement?
How optimize sql query with multiple joins in sql server?
What do you mean by an execution plan? Why is it used?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
How do you debug a procedure in sql server?
How to enter unicode character string literals in ms sql server?
What happens if null values are involved in comparison operations?
What is resource db in sql server?
What are the differences between local and global temporary tables?
What is 4nf in normalization form?
What is function of ROLLUP ?
Do you know what are the properties of the relational tables?
If the job running very slow what is the action you do