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)
-
SQL language is divided into four types of primary language statements . Follows mention regarding the four main categories of SQL stat...
-
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 ...
-
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...
No comments:
Post a Comment