What is the difference between DELETE and TRUNCATE?

Posted by Deepak on 2/5/2009 | Category: Sql Server Interview questions | Views: 6794

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

In TRUNCATE we can not rollback..
In DELETE we can rollback

Asked In: client interview | Alert Moderator

Bookmark It

< Previous : What is the difference GridView and between DataGr ...

Next > : How to Create And Delploy A WebService Using C#

Comments or Responses

Posted by: Vivekjj on: 10/5/2012 | Points: 10

delete command is used to delete particular records or whole records from the table ,But, truncate command is used to delete whole records from the table

More Interview Questions by Deepak

Latest Interview Questions

How to Create And Delploy A WebService Using C#
What’s a bubbled event ?
Between Windows Authentication and SQL Server Authentication, which on ...
Why only boxed types can be unboxed?
What’s the difference between System.String and System.StringBuilder c ...
What is the difference between Master- Detail view and MVG?
If I write System.exit (0); at the end of the try block, will the fina ...
When would you use .NET Remoting and when Web services?
More ...