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
Why do you want to join software field as you have done your BE in Electronics?
Explain something about security and SQL Azure?
What is the difference between varchar and varchar types?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Name some of the open source software that you can use in alternative to SSR?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What is trace flag in sql server?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is scrollable cursor?
How do I get to sql server configuration manager?
what is blocking? : Sql server database administration
Explain unique key in sql server?
Do you know how to make remote connection in database?
Differentiate between SQL and ORACLE joins and write their syntax.
