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

Explain how to use linked server?

1002

Explain iaas, paas and saas?

What happens if null values are involved in bitwise operations?

1041

can you instantiate a com object by using t-sql? : Sql server database administration

1010

Can binary strings be converted into numeric or float data types?

1049

How to find table changes in sql server?

1133

What is the difference between value type and reference type?

929

What is the difference between varchar and nvarchar datatypes?

1096

Can two different columns be merged into single column? Show practically?

1072

Is the primary key column of a table an index in ms sql server?

970

What is sql server agent and what are the two modes of authentication in sql server?

1067

Explain primary key in sql server?

1027

What are scalar functions in sql?

1151

What is the difference between executequery () and executeupdate ()?

1052

What are date and time data types in ms sql server?

1108