Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22136 Views
- I also Faced
- E-Mail Answers
Answer Posted / pankaj kumar upadhyay
1) When we use delete command that time we will use
conditon or without conditon but when we use truncate
command so that time we will not use condition.
2)delete can roll back but truncate is not rollback.
3)Truncate is faster compare delete command.
4)delete is DML command while Truncate is DDL.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to read data in a table with "select" statements?
What is a field name?
Explain table valued parameters in sql server? Why tvp used?
Tell me the phases a transaction has to undergo?
What is an expensive query?
What are extended events in sql server?
How to create a simple user defined function in ms sql server?
What are the disadvantages of primary key and foreign key in SQL?
What is meant by datasource?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is the language structure to add a record to a table?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Explain what is the difference between union and union all?
Why the trigger fires multiple times in single login?
Explain datetime2 data type in sal server 2008?
