Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22434 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
Explain ms sql server reporting services vs crystal reports?
How to create a view on an existing table in ms sql server?
What do you understand by triggers and mention the different types of it?
can we have a nested transaction? : Sql server database administration
What are the steps you must follow to hide sql server instances?
How to retrieve error messages using odbc_errormsg()?
What is log in sql server?
How does a profiler work?
How to create median function?
Explain what are sparse columns?
How can you insert null values in a column while inserting the data?
How to drop an existing user defined function in ms sql server?
What is a matrix in ssrs?
What is cursors? And what are the different types of cursor?
How to use values from other tables in update statements in ms sql server?
