Some more differences related to Truncate and Delete
Interview question and answer by:
Neeks | Posted on: 2/12/2009 | Category:
SQL Server Interview questions | Views: 1614 |
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.
Asked In: Many Interviews
|
Alert Moderator
Found interesting? Add this to: