Can you tell me the difference between DELETE & TRUNCATE
commands?
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
How to connect ms access to sql servers through odbc?
How to test subquery results with the exists operator?
What does indexation mean?
What are the disadvantages of using the stored procedures?
How to remove duplicate rows from table except one?
Can group functions be mixed with non-group selection fields in ms sql server?
Do you know what are the properties of the relational tables?
Explain indexed views and partitioned view with their syntax.
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What is row-level compre?
What is correlated subquery in sql server?
Explain cursor as data base object?
How do you manipulate data?
What are the extra roles available in msdb? : sql server security
What is the chart in report?