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

Explain intellisense for query editing

1029

What do you understand by a stored procedure?

1088

What is subquery explain with example?

1062

How would we use distinct statement? What is its use?

1072

What is a cursor, index in sql?

1071

Explain system scalar functions?

1001

Explain syntax for viewing trigger?

926

What is a non-clustered index?

998

Give me a SQL Query to find out the second largest company?

1166

What can be used instead of trigger?

1156

Define views.

1013

Does sql server use java?

1074

What is local temp table?

960

What is store procedure? When do you use?

936

What is mssql?

985