What is difference between TRUNCATE and DELETE statement
Answer Posted / nageswarao
truncate is used for deleting all data from table.
it is similar to delete command without condition.
main differences b/w delete & truncate are
1.truncate is faster in execution than delete which will
restructure the complete table without bothering of data.
where as delete checks the data row by row wrotes
information into log and deletes.
2.with truncate we cannot use any conditions
Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain the various types of concurrency problem?
Explain different types of index?
Does group by sort data?
What are the advantages of the mirroring?
What is precedence constraint?
What is set nocount on?
What is the use of nvl work?
How to use group functions in the select clause in ms sql server?
List the advantages of using stored procedures?
What is the usage of sign function?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What are approximate numeric data types in ms sql server?
How is sql server used?
How do you run a trace?