Can you tell me the difference between DELETE & TRUNCATE
commands?
Answer Posted / saradhi
Truncate command result can be rolled back as it is not
made an entry in the log where as Delete command result
can't be rolled back
| Is This Answer Correct ? | 5 Yes | 47 No |
Post New Answer View All Answers
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Explain alternate key, candidate key and composite key in sql server?
What are number line correlation administrators will use while working with a subquery?
How we can refresh the view?
What are the limitations/drawbacks or ssrs 2008 r2?
what types of replication are supported in sql server? : Sql server database administration
What are the differences between DDL, DML and DCL in SQL?
Which are the new data types introduced in sql server 2008?
Explain iaas, paas and saas?
What happens if we shrink log file in sql server?
How to create new table with "create table" statements?
What is query cost in sql server?
What is resultset concur_updatable?
What is sql server management studio? : sql server management studio
Why do we need normalization?