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

Answer Posted / kmbkrishnan

Delete Command require Log file updation for each row of
deleting process. But the Truncate command not.
So, the Truncate Command is so faster than Delete Command.

Is This Answer Correct ?    28 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know what are the steps to process a single select statement?

737


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1660


What is tempdb database? : SQL Server Architecture

838


What are policy management terms?

768


How to apply filtering criteria at group level with the having clause in ms sql server?

792


Do you know what is xpath?

776


Explain encryption of entire databases without the need for application changes in sql server 2008?

826


Do you know clustered and non-clustered index?

768


what is a self join? : Sql server database administration

737


What is difference between rollback immediate and with no_wait during alter database?

834


Why we need sql server?

753


What is the difference between seek predicate and predicate?

806


how you can move data or databases between servers and databases in sql server? : Sql server administration

746


How do I open a .db file?

776


Where are sql server usernames and passwords stored in the sql server?

836