Can you tell me the difference between DELETE & TRUNCATE
commands?
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
Can you leave a union at any time?
Explain the properties of sub-query in sql server?
If no size is defined while creating the database, what size will the database have?
List types of tables in SQL Azure?
Where cross join is used?
How to sort query output in descending order in ms sql server?
Can we use having clause without group by?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
what is nonclustered index
What is the sql server 2000 version number?
Explain what is use of dbcc commands?
How to concatenate two binary strings together?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How does normalization work?
How to change a login name in ms sql server?