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
How to return the second 5 rows in ms sql server?
How many categories of data types used by sql server?
How to verify a user name with sqlcmd tool?
What is #temp and @table variable in SQL server?
Explain “@@rowcount” and “@@error” in sql server?
Explain microsoft sql server functions?
Explain about system stored procedure?
What are window functions in sql server?
How to automatically create a log when an exception is being received into SQL Server?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What are the new features are introduced in sql server 2012 reporting services?
State the difference between union and union all?
What is serializable?
Explain what are various ways to enhance the ssrs report?
Explain about service Broker functions?
