Go to DotNetFunda.com
 Online : 800 |  Welcome, Guest!   Login
 
Home > Interview Questions > SQL Server Interview Questions > Some more differences related to Truncat ...

call for mock interview

SQL Server Interview Questions

Some more differences related to Truncate and Delete

Author: Neeks | Posted on: 2/12/2009 11:11:48 PM | Category: SQL Server | Views:578 |  Print | Asked In: Many Interviews


Answer:
1) Delete keep the lock over each row where Truncate keps the lock on table not on all the row

2) Counter of the Identity column is reset in Truncate where it is not reset in Delete.

3) Trigger is not fired in Truncate where as trigger is fired in Delete.

Interesting?   Share and Bookmark this


Navigate to:

 Submit Interview Questions

What is "M" language? ...

Difference between DataGrid, DataLsit and Repeater? ...

Random Interview Questions
Help: If for some reason you are getting the same question by clicking Next Question or Previous Question, Try clicking Categories link above.

Related interview questions



Advertisement

About Us | The Team | Advertise | Contact Us | Feedback | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
General Notice: If you found copied contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.
All rights reserved to DotNetFunda.Com. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks.
(Best viewed in IE 6.0+ or Firefox 2.0+ at 1024 * 768 or higher)