Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / wasimali
1) Delete command maintained the log files in each deleted row but truncate command do not maintained the log files for each deleted row but maintain the record for DE-allocation
of data-pages in the log files
2)Delete is a DML command and truncate is a DDL command.
3)Trigger is fired in case of delete command only but they are not fired when truncate command is used.
4)you can used where clause in case of delete command use to delete a particular row,
but you can not use where clause in case of truncate command use to delete a data from rows.
5) Truncate command reset the identity property to its initial values whereas delete command can not reset its identity property of its column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by an execution plan? Why is it used? How would you view it?
Do comments need to go in a special place in sql server 2005?
What are the built in functions in sql server?
What is a db view?
What is the Control Flow in SSIS
what is denormalization? : Sql server database administration
Is foreign key a primary key?
How to update a field in SQL after ALTERING a row?
Is it ok to shrink transaction log?
How do indexes help, types?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is temporary table in sql server? Why we use temp table?
What is the use of “join” in sql server?
What is Sqlpaging in SqlServer 2005 ?
