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

Does sql server use t sql?

954

when would you go for denormalization? : Sql server database administration

810

What is meant by datasource?

873

What is attribute? : sql server analysis services, ssas

978

What is a matrix in ssrs?

135

Can we take the full database backup in log shipping?

899

What are Spatial data types in SQL Server 2008

963

What do you understand by a stored procedure?

1039

Explain difference between cross join and full outer join?

953

Explain cross join or cartesian product in sql?

840

What is table level trigger?

951

Can a table be created inside a trigger?

921

What purpose does the model database server?

1054

Is it true, that there is no difference between a rule and a check constraint?

972

Can we call stored procedure in view in sql server?

860