Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24558 Views
- I also Faced
- E-Mail Answers
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
Which are the olap features?
What is the simplest way to create a new database in ms sql server?
Is foreign key a primary key?
Can sql servers linked to other servers like oracle?
How to delete multiple rows with one delete statement in ms sql server?
Describe how to use the linked server?
Explain what is the use of custom fields in report?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What is the Main Difference between ACCESS and SQL SERVER?
Where are SQL server users names and passwords are stored in sql server?
What are the different types of replication are there in sql server 2000?
What is the difference between online clustering and Offline clustering?
How to return the second 5 rows in ms sql server?
What are the five characteristics of good data?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
