What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 20194 Views
- CTS, I also Faced
- E-Mail Answers
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 is the significance of master, tempdb and model databases?
What is the index requirement in SQL Azure?
What are the different types of join?
What is a primary index?
What the different components of Replication and what is their use?
How do you make a trace?
where can you add custom error messages to sql server? : Sql server administration
How to run sql server 2005 books online on your local system?
How can you fetch alternate records from a table?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Explain the different types of backups available in sql server? : sql server database administration
Can I disable or restrict ssrs export formats (rendering formats)?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What are the differences between having and where clause.
Explain the functionalities that views support?
