Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22352 Views
- I also Faced
- E-Mail Answers
Answer Posted / kapil
Delete: is a DML command.
Truncate: is a DDL command.
Delete & Truncate both can be rolled back.
Untill you have not commit transaction.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is triggers and its types?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What are the differences between stored procedure and view in sql server?
How to create a view using data from another view?
Is the log file is a part of file group?
How will you optimize a stored procedure optimization?
What is the use of floor function in sql server?
Explain different types of collation sensitivity?
What is the chart in report?
What are functions in the sql server?
What is a result set object returned by mssql_query()?
What are the advantages of stored procedure in sql server?
Explain an automatic checkpoint
What is the recovery model?
List out a number of the wants to setup a SQL Server failover cluster?
