Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25118 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
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
How to test subquery results with the exists operator?
Explain about analysis services?
Does sql server 2016 have ssms?
What is resource db in sql server?
Why should one not prefix user stored procedures with ‘sp_’?
Why use triggers?
What are database states in ms sql server?
How do you delete duplicate records in sql server?
Why I am getting this error when dropping a database in ms sql server?
How to create a Master database in SQL server ?
What are the advantages of the mirroring?
What do you mean by collation recursive stored procedure?
How to execute multiple stored procedures at one time in sql server?
Define views.
