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
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
How to loop through result set objects using odbc_fetch_row()?
How are the unique and primary key constraints different?
What do you mean by a Composite primary key?
What do you mean by stored techniques? How would we use it?
Why do we use functions?
What are commit and rollback in sql?
What is a collation?
what is raid? : Sql server database administration
What are security principals used in sql server 2005?
How to write a query with a left outer join in ms sql server?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Explain the steps to use transact-sql cursor?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is replication and database mirroring?
