Blow mention the difference of between DELETE and TRUNCATE in MS-SQL Server.
1) Command Type
DELETE - DML(Data Manipulation Language )Command.
TRUNCATE - DDL (Data Definition Language)Command.
2) Role Back
DELETE - Can Role Back using Transactions.
TRUNCATE - Can not Role Back.
3) Identity Reset
DELETE - Identity Column didn't Reset.
TRUNCATE - Identity Column Reset.
4) Lock
DELETE - Row lock ,each row is locked to Delete.
TRUNCATE - Table lock ,whole table is locked to remove all records.
5) Where Condition
DELETE - Support for Where Condition.
TRUNCATE - Didn't Support for Where Condition.
Subscribe to:
Posts (Atom)
-
The string pool is a table that contains a single reference to each unique literal string declared in your application which use by the Com...
-
Following my Example code for describe the issue, following i have written the generic method to Search thru the list by using given sear...
-
When we use Collection in our code , sometime we need to modify (delete) collection during the Iteration. but we can't remove element d...