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 is function of ROLLUP ?
What is scalar user-defined function?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to Insert multiple rows with a single insert statement?
What are the types of lock supported by ?
What are partitioned views?
What is normalization? What number of normalization shapes are there?
What are data files?
How to loop through the result set with @@fetch_status?
Explain insert into select statement?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is query processing?
Explain about protocol layer present in SQL server?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
