Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24449 Views
- I also Faced
- E-Mail Answers
Answer Posted / kmbkrishnan
Delete Command require Log file updation for each row of
deleting process. But the Truncate command not.
So, the Truncate Command is so faster than Delete Command.
| Is This Answer Correct ? | 28 Yes | 5 No |
Post New Answer View All Answers
What is wide table?
What are rest-style architecture's?
Describe how to use linked server?
Can I delete event logs?
What happens when converting big values to numeric data types?
What is a result set object returned by mssql_query()?
What is bit data type? What's the information that can be stored inside a bit column?
What is #table in sql server?
Explain about remote stored procedure?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What stored by the master?
what happens on checkpoint? : Sql server database administration
What’s the use of custom fields in report?
Can binary strings be converted into numeric or float data types?
Explain what is the purpose of sql profiler in sql server?
