Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 21260 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 the difference between writing data to mirrored drives versus raid5 drives
What is change data capture (cdc) in sql server 2008?
What is difference statement and preparedstatement?
How do I create a partition table in sql server?
Do you know data definition language, data control language and data manipulation language?
How to how to convert numeric expression data types using the convert() function??
How do you size a resultset?
Can a database be shrunk to 0 bytes, if not, why?
What is the difference between Stored Procedures and triggers?
What are cursors stored procedures and triggers?
Do you know spatial data types - geometry and geography in sql server 2008?
What command is used to create a database in the sql server and how?
Why use “in” clause in sql server?
What does nvl stand for?
Explain what is log shipping?
