truncate provide faster processing than delete because of truncate does&#

Can you tell me the difference between DELETE & TRUNCATE
commands?

Question Posted / gk singh

Answer Posted / gk singh

truncate provide faster processing than delete because of
truncate does'n require transaction log uddation

Is This Answer Correct ?

22 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the sql case statement used for? Explain with an example?

952

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

919

What is a primary key?

910

How to change server name in sql server?

1110

What is the meaning of resultset type_scroll_insensitive?

919

Write a code to select distinct records without using the DISTINCT keyword.

1064

What is collation sensitivity?

1002

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

929

What is the command to change the recovery model?

1014

What is awe?

961

What are filegroups in sql server?

1024

How do you manipulate data?

866

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

993

What do you know about normalization and de- normalization?

881

How is sql server used?

920