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
Do you know what are the steps to process a single select statement?
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.
What is tempdb database? : SQL Server Architecture
What are policy management terms?
How to apply filtering criteria at group level with the having clause in ms sql server?
Do you know what is xpath?
Explain encryption of entire databases without the need for application changes in sql server 2008?
Do you know clustered and non-clustered index?
what is a self join? : Sql server database administration
What is difference between rollback immediate and with no_wait during alter database?
Why we need sql server?
What is the difference between seek predicate and predicate?
how you can move data or databases between servers and databases in sql server? : Sql server administration
How do I open a .db file?
Where are sql server usernames and passwords stored in the sql server?