Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Difference Between Truncate Table and Delete Table Command in SQL Server?
on 8/25/2009 | Category:
Sql Server Interview questions
| Views: 7804
In case of Delete Statement Log is maintained. while in case of truncate command log is not maintained for each row, so we can't rollback the data in case of truncate table command.
Many Interviews |
< Previous :
Which method is used to Gets the name of the speci ...
Next > :
How Can we Write the Transaction Block in SQL Serv ...
Comments or Responses
According to your answer of "Difference Between Truncate Table and Delete Table Command in SQL Server ?"
"In case of Delete Statement Log is maintained. while in case of truncate command log is not maintained for each row, so we can't rollback the data in case of truncate table command."
Pl change the answer as...
Truncate command will NEVER LOG any transactions... But you saying that "truncate command log is not maintained for each row".
another Difference are:
--> Truncate Table is faster than Delete Table,
--> Delete table accept where Clause.
--> Truncate Table reset identity column.
on: 10/5/2012 |
Truncate Table is faster than Delete Table,
Truncate delete all the records from the table
--> Delete command is used to delete particular records or whole records from the table
Login to post response
More Interview Questions by Lakhangarg
How Can we Write the Transaction Block in SQL Server?
How can we Rollback the Transaction in DataBase?
Will COUNT(column) include columns with null values in its count?
What is the page size in SQL Server?
Can UNIQUE KEY in SQL Server 2005 have two or more NULL?
What’s the difference between a primary key and a unique key?
The maximum number of columns a table can have in SQL Server?
Latest Interview Questions
Which method is used to commit all changes in the DataSet or DataTable ...
Which method is used to create a new row in a Table
How to disable the page viewstate by
disadvantages of hidden fields?
What does is Nan function do?
Difference between ASP.Net Website and ASP.Net Web Application?
Difference between Localization and Globalization?