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:
Post Comments (Atom)
-
Following my Example code for describe the issue, following i have written the generic method to Search thru the list by using given sear...
-
Step 1 – Create the Console Ø Click Start > Run (or press WIN + R) and type “ mmc.exe ” Ø This opens an empty Microsoft ...
-
If we want application force to run as Administrator on windows, how we can do that following i have describe how we can do this for .Net ...
No comments:
Post a Comment