Truncate deletes all rows from table. But Delete deletes row/rows by cond

What is the difference between truncate and delete statement?

Question Posted / rajiv singh

Answer Posted / rajiv singh

Truncate deletes all rows from table. But Delete deletes
row/rows by condition.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is self contained scalar sub query?

974

Does any body please help me what question's have asked for SSRS in the interview?

2148

What is the difference between createstatement and preparedstatement?

942

How many types of subqueries are there in sql server?

992

What is correlated subquery in sql server?

1075

Can we add a cpu to sql server?

1018

Ms sql server index?

1068

Explain Geometry datatype in sql server 2008 with example

997

What is the difference function and stored procedure?

1065

How do I setup a sql server database?

1078

Difference between primary key and clustered index?

1012

Do you know sql server 2008 backup compression?

971

Why the trigger fires multiple times in single login?

1213

What is the parse query button used for?

1040

What are the advantages to use stored procedures?

1111