Buy Questpond's video subscriptions on
huge discount
.
Online: 3827
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
Difference Between Truncate Table and Delete Table Command in SQL Server?
Posted by
Lakhangarg
on 8/25/2009 | Category:
Sql Server Interview questions
| Views: 10508
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Answer:
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.
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< 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
Posted by:
Pandians
on: 8/27/2009
Hi
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".
Cheers
Posted by:
Kapil.j.dhokai
on: 9/21/2009
another Difference are:
--> Truncate Table is faster than Delete Table,
--> Delete table accept where Clause.
--> Truncate Table reset identity column.
Posted by:
Vivekjj
on: 10/5/2012 |
Points: 10
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?
Who Developed JavaScript?
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?
What Boolean operators are not supported by JavaScript?
Difference between ASP.Net Website and ASP.Net Web Application?
Difference between Localization and Globalization?
More ...