Truncate command result can be rolled back as it is not made an entry in

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

Question Posted / saradhi

Answer Posted / saradhi

Truncate command result can be rolled back as it is not
made an entry in the log where as Delete command result
can't be rolled back

Is This Answer Correct ?

5 Yes

47 No

Please Help Members By Posting Answers For Below Questions

What is schemabinding a view?

971

Is mysql the same as sql server?

1032

How to update muliple row in single query?

1116

What are the triggers in sql?

1168

Define union, union all, minus, intersect?

1034

Explain index in sql server?

1066

What are the acid properties?

1059

What is primary key, unique key, and foreign key?

1016

What is exporting utility?

1086

Is it possible to replicate data from sql server to oracle? : sql server replication

1140

How do I find the query plan in sql server?

1018

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1005

What is dbcc command in sql server?

1151

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2856

How to execute function in stored procedure sql server?

1235